Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Problems running addtables on db2 on z/os

if you happen to run into a:
SQLCODE=-904, SQLSTATE=57011, SQLERRMC=00D70025;00000220;DB0TC.DSNDBC.DW60.TEST1EFN.I0001.A001, DRIVER=4.16.53

0 votes



One answer

Permanent link
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


0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,494

Question asked: Jan 20 '16, 8:49 a.m.

Question was seen: 4,117 times

Last updated: Jan 20 '16, 9:50 a.m.

Confirmation Cancel Confirm