DB2 problem on AIX

[surya12]

Hi

I'm getting SQL1224 error code when I connect to DB2 on AIX 4.3.3 from a Java application. If I do the same thing from a C/C++ application, I'm not getting this problem. Did anybody face this problem? Do I need to set any parameters for this?
P.S. I already set the variable SHMEXT to ON.

Thanks in advance,
Surya

 

[Yegolev]

Thinking logically, if it works from a C prog, the DB is fine. AIX has no interaction with SQL. Therefore it must be a coding issue. Perhaps innacurate quoting in the java prog. Perhaps try running SQL from an external file in both C and Java, see if it is SQL problem or Java problem.

Note that I am not a DBA. IBM Certified -- AIX 4.3 Obfuscation

 

[surya12]

Hi

You may be right, but my point is that the same Java application runs on Windows NT, 2000 and Solaris 2.6, 7 etc. There's no difference at all in the code. Only porting to AIX gives the problem. So, I'm thinking that the configuration or setting some flags (like SHMEXT=ON) should be done on AIX.

Bye