PQ56876: SQLCODE407 ABENDU0002 TRIGGERED BY SMF30-4 RECORD BUT DUMP SHOWSTHE FIELD IS VALID BUT THE NULL FLAG IS INCORRECTLY SET TO X'FF'

APAR status

• Closed as unreproducible in next release.

Error description

• sqlcode407 abendu0002 from smf30-4 MVS_SYSTEM_ID column which,
  although not actually null, has null flag set to x'FF' which
  tells DB/2 that the field is null causing sqlcode -407 and
  results in a TDS/390 abendu0002. Record can be removed, the
  log collected, and then the individual record can be collected
  w/o changing it.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Randomly, some T.D.S. 1.5.0 users            *
  *                 working with DB2 V6.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Random, one TDS 1.5.0 user              *
  *                      working with DB2 V6,                    *
  *                      collecting SMF30_4 records got          *
  *                      following message :                     *
  *                      "SQLCODE407 ABENDU0002" TRIGGERED       *
  *                      BY SMF30-4 RECORD BUT DUMP SHOW         *
  *                      THE FIELD IS VALID BUT                  *
  *                      THE NULL FLAG IS INCORRECTLY            *
  *                      SET TO X'FF."                           *
  *                      This apar was closed                    *
  *                      UR1 (Unable to Reproduce).              *
  *                      Probably problem was due                *
  *                      to other, not reproducible              *
  *                      environment reasons.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Random, one TDS 1.5.0 user
  working with DB2 V6,
  collecting SMF30_4 records got
  following message :
  "SQLCODE407 ABENDU0002" TRIGGERED
  BY SMF30-4 RECORD BUT DUMP SHOW
  THE FIELD IS VALID BUT
  THE NULL FLAG IS INCORRECTLY
  SET TO X'FF."
  This apar was closed
  UR1 (Unable to Reproduce).
  Probably problem was due
  to other, not reproducible
  environment reasons.
  

Problem conclusion

Temporary fix

Comments

• Random, one TDS 1.5.0 user
  working with DB2 V6,
  collecting SMF30_4 records got
  following message :
  "SQLCODE407 ABENDU0002" TRIGGERED
  BY SMF30-4 RECORD BUT DUMP SHOW
  THE FIELD IS VALID BUT
  THE NULL FLAG IS INCORRECTLY
  SET TO X'FF."
  This apar was closed
  UR1 (Unable to Reproduce).
  Probably problem was due
  to other, not reproducible
  environment reasons.
                 -------
  After a lot of tests, problem
  isn't reproducible into
  Lab env.
  Also into customer env, problem
  random occurred.
  Pmr submittor of this apar
  was closed.
  

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

  EPDM VERSION 1

• Fixed component ID

  569510100

Applicable component levels

• R501 PSN

     UP