PK70174: SYNTAX ERROR IN JCR UPGRADE SCRIPTS FOR DB2 Z/OS

APAR status

• Closed as program error.

Error description

• This APAR removes a syntax error in the SQL script that
  upgrades
  parts of the JCR database domain on DB2 for z/OS.
  .
  Affected users:
  Customers migrating from Portal 6.0 to Portal 6.1 and having
  the
  JCR domain on DB2 for z/OS.
  

Local fix

Problem summary

• This APAR removes a syntax error in the SQL script that
  upgrades parts of the JCR database domain on DB2 for z/OS.
  
  The APAR is needed if this error message can be observed:
  
       [sqlproc] CREATE TABLE L25DBADM.APPROLE_LOD (
  
          [sqlproc]     APPROLE_OID CHAR(18) FOR BIT DATA NOT
  NULL,
  
          [sqlproc]     LOCALE VARCHAR(64) NOT NULL,
  
          [sqlproc]     TITLE VARGRAPHIC(255) NOT NULL,
  
          [sqlproc]     DESCRIPTION VARGRAPHIC(1024),
  
          [sqlproc]     CONSTRAINT PK2235 PRIMARY KEY
  (APPROLE_OID, LOCALE),
  
          [sqlproc]     CONSTRAINT FK2235 FOREIGN KEY
  (APPROLE_OID) REFERENCES L25DBADM.APPLICATION_ROLE (OID) ON
  DELETE CASCADE
  
          [sqlproc] )
  
          [sqlproc] Error during statement execution!
  
          [sqlproc] com.ibm.db2.jcc.c.SqlException: DB2 SQL error:
  SQLCODE: -879, SQLSTATE: 53095, SQLERRMC:
  L25DBADM.APPROLE_LOD;EBCDIC
  
          [sqlproc]  at com.ibm.db2.jcc.c.kh.c(kh.java:1660)
  
          [sqlproc]  at com.ibm.db2.jcc.c.kh.d(kh.java:1648)
  
          [sqlproc]  at com.ibm.db2.jcc.c.kh.b(kh.java:1159)
  
          [sqlproc]  at com.ibm.db2.jcc.b.db.h(db.java:219)
  
          [sqlproc]  at com.ibm.db2.jcc.b.db.b(db.java:46)
  
          [sqlproc]  at com.ibm.db2.jcc.b.t.b(t.java:40)
  
     [...]
  

Problem conclusion

• Corrections in the corresponding SQL scripts. SQL script will
  be replaced.
  
  Failing Module(s):
     Database
  
  Affected Users:
     Migration from 6.0 to 6.1 and JCR domain on DB2 for z/OS
  
  Version Information:
      Portal Version(s): 6.1.0.0
       Pre-Requisite(s):
        Co-Requisite(s): ---
  
  Platform Specific:
     This fix applies to all platforms.
  
  A fix is available from Fix Central:
  
  http://www.ibm.com/eserver/support/fixes/fixcentral/swgquickorde
  r?apar=PK70174&productid=WebSphere%20Portal&brandid=5
  
  You may need to type or paste the complete address into your Web
  browser.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WEBSPHERE PORTA

• Fixed component ID

  5724E7600

Applicable component levels

• R610 PSY

     UP