IBM Support

PM81578: AFTER CREATING RAA DATABASE, EXCEPTION WITH ERRORCODE=-4228 OCCURS WHEN TRYING TO WRITE TO DATABASE

Fixes are available

Rational Asset Analyzer 6.1
Rational Asset Analyzer for System z 6.1
Rational Asset Analyzer Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer for System z Fix Pack 3 (6.1.0.3) for 6.1
Rational Asset Analyzer Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer for System z Fix Pack 4 (6.1.0.4) for 6.1
Rational Asset Analyzer Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 5 (6.1.0.5) for 6.1
Rational Asset Analyzer for System z Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 6 (6.1.0.6) for 6.1
Rational Asset Analyzer Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 7 (6.1.0.7) for 6.1
Rational Asset Analyzer for System z Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer Fix Pack 8 (6.1.0.8) for 6.1
Rational Asset Analyzer for System z Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 9 (6.1.0.9) for 6.1
Rational Asset Analyzer Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer for System z Fix Pack 10 (6.1.0.10) for 6.1
Rational Asset Analyzer Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer for System z Fix Pack 11 (6.1.0.11) for 6.1
Rational Asset Analyzer Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer for System z Fix Pack 12 (6.1.0.12) for 6.1
Rational Asset Analyzer Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Client is installing RAA for System z and is able to create RAA
    database, but when running job that writes data to populate new
    database, an error occurs indicating that access to the
    database using JDBC failed with Return Code=12, Reason
    Code=X00F30006 and ERRORCODE=-4228 .
    

Local fix

  • none known
    

Problem summary

  • SQLRuntimeException with ERRORCODE=-4228 creating/populatin a
    database on z/OS.
    

Problem conclusion

  • Updated SetupJdbc.sh to include an example of setting up
    environment variables when using the JCC JDBC driver.
    

Temporary fix

  • update DB2's DB2JccConfiguration.properties with
    db2.jcc.ssid=SSID_value
    where SSID_value is the subsystem ID of the DB2 system,
    and update RAA for System z's SetupJdbc.sh file if using the
    Universal JDBC driver (JCC driver) and the
     DB2JccConfiguration.properties file is in the /etc directory
    to contain a statement such as:
    export
    CLASSPATH=/usr/lpp/db2910_jdbc/classes/db2jcc.jar:/etc:$CL
    ASSPAT H
    

Comments

APAR Information

  • APAR number

    PM81578

  • Reported component name

    RAA FOR SSTEM Z

  • Reported component ID

    5655W5700

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-01-28

  • Closed date

    2013-01-28

  • 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

  • DMH0731
    jdbcsetu
    

Fix information

  • Fixed component name

    RAA FOR SSTEM Z

  • Fixed component ID

    5655W5700

Applicable component levels

  • R600 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS3JHP","label":"Rational Asset Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
07 February 2013