Hello List,
My current environment is Z/OS V 1.7 and DB2 V 7.1
I am migrating from Tivoli Decision Support for Z/OS Version 1.5.1 to TDS
1.6.0.
My problem is when I run data collection job I get a -407 abend . SQLSTATE is
23502
(An insert or update value is null, but the column cannot
contain null values.) .
I ran the collection program with SQL trace option which is
&ZZSQLSHOW=STMT. The trace shows the last call before abend -407
is insert to MVS_ACCNT23_PGM_T. I listed URLUPDATES table. The
information from the table about MVS_ACCNT23_PGM_T is as follows:
UPDATE NAME MVS_ACCNT23_PGM_T
SOURCE SMF_030_2_3_X
TARGET MVS_ACCNT23_PGM_T
In this run of the collection program, this is the first insert to table
MVS_ACCNT23_PGM_T. In one of my earlier run of the collection program,
two inserts to the table were successful. The third insert abended.
If I run the same job with version 1.5.1 libraries, the collection
job runs successfully although I have migrated the tables to Version 1.6.1.
Thanks for any feedback
Ale
---------------------------------
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail Beta.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
