SQLCODE=-204 SQLSTATE=42704

mughais27 · New User Joined: 14 Feb 2020 Posts: 2 Location: India

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

Nic Clouston · Posted: Fri Feb 14, 2020 6:29 pm

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)

Rohit Umarjikar · Posted: Fri Feb 14, 2020 6:30 pm

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.

enrico-sorichetti · Posted: Fri Feb 14, 2020 7:12 pm

why not contact the OPTIM providers ?

mughais27 · New User Joined: 14 Feb 2020 Posts: 2 Location: India

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