IBM Support

The IBM Tools Customizer-generated BIND job, A5BINDAB, for DB2 High Performance Unload for z/OS (DB2 HPU) fails with condition code 0008

Troubleshooting


Problem

The BIND job that was generated by Tools Customizer for DB2 HPU fails with condition code 8. The name of the template that corresponds to the job is INZBIND.

Symptom

The BIND job that was generated from the INZBIND template by Tools Customizer for DB2 HPU fails with condition code 8, and the following messages are issued in SYSTSPRT:

     BIND PACKAGE(HPUPKG) MEMBER(INZSDBA)     RELEASE(COMMIT) ISOLATION(CS) VALIDATE(RUN)     DYNAMICRULES(RUN) OWNER(DB2SYS1) ENCODING(ASCII)
 DSNX200I  -DM21 BIND SQL ERROR
            USING DB2SYS1 AUTHORITY
            PLAN=(NOT APPLICABLE)
            DBRM=INZSDBA
            STATEMENT=69
            SQLCODE=-189
            SQLSTATE=22522
            TOKENS=65534
            CSECT NAME=DSNXOASG
            RDS CODE=-810
 DSNT233I  -DM21 UNSUCCESSFUL BIND FOR
            PACKAGE = MDB2DDF.HPUPKG.INZSDBA.(HZ4590)

Cause

The MIXED DATA field (MIXED DSNHDECP value) setting of the DB2 subsystem's ZPARM setting does not match the HPU INZTVAR VZD015/MIXED setting.

Specifying YES in the Mixed Mode field on the DB2 Parameters panel in Tools Customizer causes Tools Customizer to generate the INZSDBA package with ENCODING(ASCII).

Resolving The Problem

The DB2 DSNHDECP MIXED DATA option setting and the HPU value setting of VZD015/MIXED (specified in the Mixed Mode field on the DB2 Parameters panel in Tools Customizer) must be identical.

  • If the DB2 DSNHDECP setting is MIXED=YES, specify YES in the Mixed Mode field.
  • If the DB2 DSNHDECP setting is MIXED=NO, specify NO in the Mixed Mode field.


You will find the HPU Mixed Mode field is on the Tools Customizer (TCz) DB2 Parameters CCQPDB2 panel.
For example, the following:

   General DB2 Information
    Mode . . . . . . . . . . . . NFM (CM, CM8, CM9, NFM)
    Level number . . . . . . . . 101 (810, 910, 101, 111)
    Mixed mode . . . . . . . . . NO  (YES, NO)


After specifying the correct value in the Mixed Mode field, regenerate the BIND job for the DB2 entry. Edit the generated BIND job, if necessary, and submit it. The job will end with RC=4 or RC=0.
For example, binding DB2 HPU on DB2 10 NFM will end with return code 4 and the following warning messages:
  • SYSIBM.SYSVTREE IS NOT DEFINED
  • SYSIBM.TABLESPACESTATS IS NOT DEFINED
  • SYSIBM.INDEXSPACESTATS IS NOT DEFINED

[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DB2 High Performance Unload","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"4.2.0;4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021

UID

swg21618898

Page Feedback