IBM Support

IV75370: UPGRADING TWS 9.2.1 TO 9.2 FIXPACK 2 WITH ORACLE DB HANGS AT 99%,

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Env:
    TWS 9.1.1
    Oracle DB
    
    ERROR:
    User is installing 9.1 fixpack 2 and the installer hangs at
    99%.  These are the errors that appear:
    
    "GLSTEST" is not a TWS 8.6.0.00 database. The upgrade will not
    be
    executed.
    0
    Database GLSTEST already has nullable PWKS_ID column in table
    PJOR_JOB_RUNS.
    SELECT COUNT(PJST_DELTA_JOBS) FROM TWS_ADMIN.PJST_JOB_STREAMS
                 *
    ERROR at line 1:
    ORA-00904: "PJST_DELTA_JOBS": invalid identifier
    ...
    Database "GLSTEST" has been successfully upgraded to the
    following
    version: PJSTDELTAJOBS
    SP2-0310: unable to open file
    "../sql/check_PJST_PEND_PRED_FLAG.sql"
    

Local fix

  • User looked in the check_PJSTPENDPRED.sql file and saw that it
    was
    referencing PJST_PEND_PRED_FLAG.  They then linked the two
    together
    check_PJST_PEND_PRED_FLAG.sql -> ./check_PJSTPENDPRED.sql
    issued a kill -HUP on the pid for the sqlplus that this was
    hanging on.
    The process completed and the installer completed also.  It
    says that
    FP2 was successfully installed.
    

Problem summary

  • The installation code has been fixed to call the right sql file
    to check the field PJST_PEND_PRED_FLAG of the table
    PJST_JOB_STREAMS
    

Problem conclusion

  • This APAR will be fixed in TWS 9.1.0-TIV-TWS-FP0003
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV75370

  • Reported component name

    TIV WKLD SCHDL

  • Reported component ID

    5698WKB91

  • Reported release

    9L1

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-07-21

  • Closed date

    2015-09-09

  • Last modified date

    2015-09-09

  • 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

    TIV WKLD SCHDL

  • Fixed component ID

    5698WKB91

Applicable component levels

  • R9L1 PSY

       UP



Document information

More support for: IBM Workload Scheduler

Software version: 9L1

Reference #: IV75370

Modified date: 09 September 2015