Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQLCODE=-204 SQLSTATE=42704

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

New User


Joined: 14 Feb 2020
Posts: 2
Location: India

PostPosted: Fri Feb 14, 2020 5:04 pm    Post subject: SQLCODE=-204 SQLSTATE=42704
Reply with quote

Hi All,

We are using OPTIM for masking our data and we rolled out a PTF recently to fix an issue that the tool was causing. After the PTF was rolled out we were required to re-bind the existing packages. When I try to do that I am seeing the below error,

DSNX200I -DB2O BIND SQL ERROR
USING S003132 AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=FOPD2ANN
STATEMENT=2716
SQLCODE=-204
SQLSTATE=42704
TOKENS=S003132.FOP_ADB2AUDIT
CSECT NAME=DSNXOTL
RDS CODE=-500
DSNT233I -DB2O UNSUCCESSFUL BIND FOR
PACKAGE = DB2OLOC1.FOPPACKAGEMB.FOPD2ANN.(UI22100)

Here is the subcommand that is being executed,

BIND PACKAGE (FOPPACKAGEMB) MEMBER(FOPD2ANN) LIBRARY('SYS4.TST1.OPTIMB30.SFOPIN
ST') ACTION(ADD) SQLERROR(NOPACKAGE) VALIDATE(BIND) ISOLATION(CS) FLAG(I) RELEAS
E(COMMIT) EXPLAIN(NO) CURRENTDATA(YES) ENCODING(EBCDIC)

Could someone please let me know what the issue could be? I do have proper authorizations in place to bind packages in the DB2 subsystem.

Any help would be highly appreciated.

Thanks
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2351
Location: Hampshire, UK

PostPosted: Fri Feb 14, 2020 6:29 pm    Post subject: Reply to: SQLCODE=-204 SQLSTATE=42704
Reply with quote

Have you actually searched for the meaning of the -204?

Also, please use the code tags when posting code and data. (Look at the buttons over the text entry box)
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2382
Location: NY,USA

PostPosted: Fri Feb 14, 2020 6:30 pm    Post subject:
Reply with quote

https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/codes/src/tpc/n204.html

Check the mentioned token in that program, it doesn’t exist or accessible. Or check in the catlog tables.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10681
Location: italy

PostPosted: Fri Feb 14, 2020 7:12 pm    Post subject: Reply to: SQLCODE=-204 SQLSTATE=42704
Reply with quote

why not contact the OPTIM providers ?
Back to top
View user's profile Send private message
mughais27

New User


Joined: 14 Feb 2020
Posts: 2
Location: India

PostPosted: Mon Feb 17, 2020 12:03 pm    Post subject:
Reply with quote

Thanks guys for sharing your thoughts on this! The problem was lack of synonyms for the SYSIBM.* tables. I created that and it worked fine for me.

Thanks
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 Getting sqlcode 805 while executing R... abdulrafi DB2 10 Thu Dec 26, 2019 11:46 am
No new posts SQLCODE -950 in PREPARE statement ... PeD DB2 2 Sat Apr 20, 2019 7:00 pm
No new posts How to resolve sqlcode of CALL ATTACH... maxsubrat DB2 3 Fri Feb 22, 2019 11:54 am
No new posts Sqlcode =-253 pkmurali DB2 6 Sun Jul 22, 2018 3:13 pm
No new posts SQLCODE 518 while executing DB2 module. abdulrafi DB2 8 Wed Feb 07, 2018 10:46 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us