PI86073: CREATE_USER_ID AND UPDATE_USER_ID COLUMNS SET TO ZERO (USER_NAME = UNKNOWN)

RAAzInstall
RAAzInstallRepository
RAAInstallRepository
RAAInstall
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
Rational Asset Analyzer Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1
Rational Asset Analyzer Fix Pack 23 (6.1.0.23) for 6.1

APAR status

• Closed as program error.

Error description

• CREATE_USER_ID and UPDATE_USER_ID columns set to zero
  (USER_NAME = Unknown)
  

Local fix

• None Known
  

Problem summary

• Under some scenarios, the CREATE_USER_ID and UPDATE_USER_ID
  columns in various RAA tables contain a value of zero. In
  addition, related instances of the UPDATE_TIMESTAMP column are
  not being properly reset with the current date and time value.
  

Problem conclusion

• Corrections have been made for database INSERTs and batched
  statements that were not matching/setting the current user ID
  value for the create and update columns of interest, and
  setting the current date and time value to reflect when the
  metadata was last changed.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• COLUMNS
  

Fix information

• Fixed component name

  RAA FOR SSTEM Z

• Fixed component ID

  5655W5700

Applicable component levels

• R610 PSY

     UP