IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

SQLCODE=-204 SQLSTATE=42704


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 2432
Location: Hampshire, UK

PostPosted: Fri Feb 14, 2020 6:29 pm
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

Global Moderator


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

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

Use [URL] BBCode for Links

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: 10697
Location: italy

PostPosted: Fri Feb 14, 2020 7:12 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts Getting sqlcode 805 while executing R... DB2 10
No new posts SQLCODE -950 in PREPARE statement ... DB2 2
No new posts How to resolve sqlcode of CALL ATTACH... DB2 3
No new posts Sqlcode =-253 DB2 6

Back to Top