Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Problem - CAF "OPEN" failed using DB2 system:D

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Wed Mar 01, 2006 2:47 pm    Post subject: DB2 Problem - CAF "OPEN" failed using DB2 system:D
Reply with quote

Hi

I'm getting following abend when im executing cobol-db2 program.

IDI0089I Subsystem IDISDB2P RC=C, Rsn=40000004 ODBC DLL function
DSNAOCLI not found..Subsystem IDIS subtask termination rc=C 40000004.
IDI0082E DB2 Call Level Interface error: SQLAllocConnect SqlError
sqlrc=-1.{DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=58004
ERRLOC=2:170:10. CAF "OPEN" failed using DB2 system:DB2M and

Please advise me what could be the problem.
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Wed Mar 01, 2006 3:24 pm    Post subject: Re: Ugent:::DB2 Problem
Reply with quote

And what is the SQLCODE you received.

Regards,
Priyesh.
Back to top
View user's profile Send private message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Wed Mar 01, 2006 3:35 pm    Post subject: Re: Ugent:::DB2 Problem
Reply with quote

Hi

Actually i didnt see any SQL Code But status is job cancelled. Please advise me ...
Back to top
View user's profile Send private message
small_world

New User


Joined: 22 Jul 2005
Posts: 24
Location: pune

PostPosted: Thu Mar 02, 2006 3:18 pm    Post subject:
Reply with quote

error message SQLSTATE=58004 when performing update and delete operations when the index is created on columns

If an index is created on a column position that exceeds 256, data corruption may occur or SQLSTATE 58004 will be returned. This fix also prevents creating a table with more than 256 columns.

58004 when trying to access a database that is stored on an external media (for example, SD Card, CompactFlash Card, and IBM Microdrive) on a PalmOS device.

SQLState 58004 when joining two tables with a join condition that involves VARCHAR colums containing empty strings (when an index is being used for fetching data).
Back to top
View user's profile Send private message
ykishore

New User


Joined: 12 Aug 2005
Posts: 53
Location: USA

PostPosted: Thu Mar 02, 2006 3:30 pm    Post subject: Re: Ugent:::DB2 Problem
Reply with quote

Hi

Actually, I have a COBOL-DB2 program. when i tried to execute that, it is going to loop. So can you guys let me know causes for that? My program is simply selecting the data from DB2 table using Cursor. Please let me know the causes...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts FTP - JCL failed while passing FTP co... Suneetha1612 JCL & VSAM 12 Wed Nov 16, 2016 7:33 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us