PM56645: RAA MIGRATION UTILITY FOR SYSTEM Z ( DBUTIL.SH ) FAILS WHEN USING A RUNTIME DATABASE IN DB2 V10 NEW FUNCTION MODE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When the RAA for System z database is in DB2 V10 New Function
    Mode, and the migration utility, dbutil.sh, is run against it,
    errors such as the following are issued and no information
    collection or migration can take place:
    
    java.lang.StringIndexOutOfBoundsException: String index out of
    range: -1
    java.lang.String.substring(String.java:1072)
    .at com.ibm.dmh.db.DbMetaData.<init>(Unknown Source)
    .at com.ibm.dmh.db.DbAdmin.initializeJdbc(Unknown Source)
    .at com.ibm.dmh.dbutil.Main.initDb(Main.java:155)
    .at com.ibm.dmh.dbutil.Main.main(Main.java:547)
    Problem occurred while trying to access database.
    

Local fix

  • Do not use DB2 V10 New Function mode for RAA for System z
    database.
    

Problem summary

  • StringIndexOutOfBoundsException error occurs when executing in
    DB2 for z/OS V10 environment during:
        - creation of a new RAA database
        - servlet start-up for the browser interface
        - execution of RAA Migration Utility commands
    The exception message is displayed as follows:
    java.lang.StringIndexOutOfBoundsException: String index out of
    range: -1
    
    at java.lang.String.substring(String.java:1067)
    
    
    at com.ibm.dmh.db.DbMetaData.<init>(Unknown Source)
    
    
    at com.ibm.dmh.db.DbAdmin.initializeJdbc(Unknown Source)
    
    
    at com.ibm.dmh.db.DbAdmin.initialize(Unknown Source)
    
    
    at
    com.ibm.dmh.CommonInitializer.init(CommonInitializer.java:143)
    
    at
    com.ibm.dmh.CommonInitializer.init(CommonInitializer.java:56)
    
    at com.ibm.dmh.db.DbModelLoader.main(DbModelLoader.java:25)
    

Problem conclusion

  • Use of the TEXT column from the SYSIBM.SYSTRIGGERS catalog
    table has changed in DB2 for z/OS V10.  RAA now retrieves the
    full text of create trigger statements from the new STATEMENT
    column of the same table.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM56645

  • Reported component name

    RAA FOR SSTEM Z

  • Reported component ID

    5655W5700

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-24

  • Closed date

    2012-01-26

  • Last modified date

    2013-02-07

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

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

Modules/Macros

  • systrig
    

Fix information

  • Fixed component name

    RAA FOR SSTEM Z

  • Fixed component ID

    5655W5700

Applicable component levels

  • R600 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Asset Analyzer

Software version:

6.0

Reference #:

PM56645

Modified date:

2013-02-07

Translate my page

Machine Translation

Content navigation