It's all about the answers!

Ask a question

Problems running addtables on db2 on z/os

Kim Soederhamn (1.5k24146) | asked Jan 20 '16, 8:49 a.m.
edited Jan 20 '16, 9:50 a.m.
if you happen to run into a:
SQLCODE=-904, SQLSTATE=57011, SQLERRMC=00D70025;00000220;DB0TC.DSNDBC.DW60.TEST1EFN.I0001.A001, DRIVER=4.16.53

One answer

permanent link
Kim Soederhamn (1.5k24146) | answered Jan 20 '16, 8:54 a.m.
the error above can happen when you run createTables
I can be caused by the  ICF CATALOG running out of free space - your DBA should be able to help you here.

If you get the SQLCODE=-601 (duplicate name) this can happen also when you run createTables - this can be caused by a previous attempt to create tables that failed  - so even though the script should drop existing tables it will not do this in all cases and you may have to drop all the vews, and stuff yourself(a data explorer from RDZ could be handy) before running the createTables again

Your answer

Register or to post your answer.