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
 

 

SQLCODE -30090 When again processing Para-1

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

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Tue Jul 03, 2007 12:39 pm    Post subject: SQLCODE -30090 When again processing Para-1
Reply with quote

Hello,

I have Commit and rollback logic like this.

Code:
Para-1.
Insert table-A
     add 1 to counter
Insert table-A
     add 1 to counter.

if counter = 2
   perform para-2.

Para-2.
   exec sql commit.
   move zero to counter.


When again processing Para-1, we are getting SQLCODE -30090 error.
How can this be solved.

Quote:
FYI: We are accessing remote database
Back to top
View user's profile Send private message

UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 743
Location: Germany

PostPosted: Tue Jul 03, 2007 2:20 pm    Post subject:
Reply with quote

Hi !

Does this has something to do with the point, that DB2 UDB does not support 2 phase commit over TCPIP ???

If yes, DB2DRDA1READONLY=NO for UDB

Attention: IBM declared: to use only at your own risk !!!

Read more at IBM on the web !!!

Regards, UmeySan
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 Run stats processing on zIIP Engine Virendra Shambharkar DB2 9 Fri Oct 14, 2016 10:24 am
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Extracting Information from DD Statem... Charles Wolters All Other Mainframe Topics 7 Wed Apr 13, 2016 10:21 pm
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm


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