View previous topic :: View next topic
|
Author |
Message |
ramsfm
New User
Joined: 05 May 2006 Posts: 12 Location: Pune
|
|
|
|
Hi,
Can any one suggest me what are the possibilties for getting
SQLCODE -904 and how can we resolve that.
I am facing the below error , while executing COBOL-DB2 component.
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABL RESOURCE 00000210, AND RESOURCE NAME TSHRT .SSHTRME .00000015
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE.
Thanks,
Ramesh. |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
Back to top |
|
|
ramsfm
New User
Joined: 05 May 2006 Posts: 12 Location: Pune
|
|
|
|
Thanks for reply.
I want to check whether that table is exiting in dev region or not,
is it possible to know by excuting any sql or by seraching any catalog tables.
Please help on that. |
|
Back to top |
|
|
harry
New User
Joined: 27 Mar 2006 Posts: 31
|
|
|
|
Hi,
After each load we have to firstly take the imagecopy of the database.If next time you will try to load the data or you want to do any operation with Db-2 it will give you the sql return of -904.
Here in your case PART 210 OF YOUR DATA BASE IS CREAING THE PROBLEM SO YOU HAVE TO TAKE THE IMAGECOPY BY FOLLOWING COMMANDS:
INCLUDE TABLESPACES TABLESPACE DATABASE.TABLESPACE PARTLEVEL (210)
Hope it will resolve your problem.
Regards
Harry |
|
Back to top |
|
|
|