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 CICS -923 SQLCODE Problem

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

New User


Joined: 31 Aug 2005
Posts: 82

PostPosted: Tue Feb 23, 2010 8:47 pm    Post subject: DB2 CICS -923 SQLCODE Problem
Reply with quote

Hi,

Please help me about the following message:

Code:
 TRANSACTION: BTAC PROGRAM: SY0181   TASK: 0000151 APPLID: CICSU3A1 DISPLAY:  00
  STATUS:  COMMAND EXECUTION COMPLETE                                           
  CALL TO RESOURCE MANAGER DSNCSQL                                             
  EXEC SQL OPEN                              P.AUTH=CICSU3A1, S.AUTH=           
  PLAN=CEPL,     DBRM=DBIOBTAC, STMT=00599, SECT=00002                         
  SQL COMMUNICATION AREA:                                                       
   SQLCABC      = 136                                            AT X'1892C738'
   SQLCODE      =   -923                                         AT X'1892C73C'
   SQLERRML     = 070                                            AT X'1892C740'
   SQLERRMC     = ' ACCESS,00E30301,00000800,CEPL           '    AT X'1892C742'
   SQLERRP      = 'DSNAET03'                                     AT X'1892C788'
   SQLERRD(1-6) =  000,  000, 00000, 0000000000, 00000,  000     AT X'1892C790'
   SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _'                        AT X'1892C7A8'
   SQLSTATE     = 57015                                          AT X'1892C7B3'
                                                                               
                                                                               
                      LINE:UNKNOWN        EIBFN=X'0612'                         



Many thanks
Manshadi
Back to top
View user's profile Send private message

Manshadi

New User


Joined: 31 Aug 2005
Posts: 82

PostPosted: Tue Feb 23, 2010 8:49 pm    Post subject: DB2 CICS -923 SQLCODE Problem
Reply with quote

Hi,

Do you have any idea about the following message:
Code:
 TRANSACTION: BTAC PROGRAM: SY0181   TASK: 0000151 APPLID: CICSU3A1 DISPLAY:  00
  STATUS:  COMMAND EXECUTION COMPLETE                                           
  CALL TO RESOURCE MANAGER DSNCSQL                                             
  EXEC SQL OPEN                              P.AUTH=CICSU3A1, S.AUTH=           
  PLAN=CEPL,     DBRM=DBIOBTAC, STMT=00599, SECT=00002                         
  SQL COMMUNICATION AREA:                                                       
   SQLCABC      = 136                                            AT X'1892C738'
   SQLCODE      =   -923                                         AT X'1892C73C'
   SQLERRML     = 070                                            AT X'1892C740'
   SQLERRMC     = ' ACCESS,00E30301,00000800,CEPL           '    AT X'1892C742'
   SQLERRP      = 'DSNAET03'                                     AT X'1892C788'
   SQLERRD(1-6) =  000,  000, 00000, 0000000000, 00000,  000     AT X'1892C790'
   SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _'                        AT X'1892C7A8'
   SQLSTATE     = 57015                                          AT X'1892C7B3'
                                                                               
                                                                               
                      LINE:UNKNOWN        EIBFN=X'0612'                         


Best regards
Manshadi
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Tue Feb 23, 2010 8:59 pm    Post subject: Reply to: DB2 CICS -923 SQLCODE Problem
Reply with quote

Have you made any attempt to research these errors yourself icon_question.gif

The last EIB Function (EIBFN) of X'0612' equates to an 'ENDBR'.

Bill
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Feb 23, 2010 10:04 pm    Post subject:
Reply with quote

open DB2 manual : Messages & codes

search -923

search 00E30301
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 CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm


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