Unable to connect DB2 Server via DB2 Enterprise Stage

pmishra · Post by **pmishra** » Sat Aug 30, 2008 5:32 am

Hi All,

We are facing a unique type of error while connecting to DB2 Enterprise Stage from DataStage PX.

The error is:

"##E TNDB 000000 07:58:33(001) <FCT_FILE_DUP> Error Idx = 1;

DB2 Driver Embedded SQL message: SQL0304N A value cannot be assigned to a host variable

because the value is

not within the range of the host variable's data type. SQLSTATE=22003

;

sqlcode = -304;

sqlstate = 22003

##E TNDB 000000 07:58:33(002) <FCT_FILE_DUP> Failed to connect to database."

Will be glad if any one have provide the solution for the same.Pls help.

Thanks and regards,
Pawan

chulett · Post by **chulett** » Sat Aug 30, 2008 7:59 am

Welcome! :D

Is this the same problem as posted here?

http://www.dsxchange.com/viewtopic.php?t=121802

pmishra · Post by **pmishra** » Mon Sep 01, 2008 6:17 am

chulett wrote:Welcome! :D

Is this the same problem as posted here?

http://www.dsxchange.com/viewtopic.php?t=121802 ...

Hi ALL,

Ys the post is same...but we didn't get the solution yet.

One more info i would like to add here is previously we have AIX 5.3, ML-07 SP01 on the AIX server, but now a new patch named AIX 5.3 ML-07 SP-04. The problem infact came after the new patch installed.

This patch has been installed on both ETL and DB2 Servers.

If anybody ever faced this issue...pls let me know the solution...We are in real urgency...

Thanks and regards,
Pawan

ray.wurlod · Post by **ray.wurlod** » Mon Sep 01, 2008 6:39 am

pmishra wrote:... but now a new patch named AIX 5.3 ML-07 SP-04. The problem infact came after the new patch installed.

How to avoid stating the bleeding obvious...?

If you want urgent help sign up with your support provider for premium service and learn the true cost of "urgent". DSXchange is an all-volunteer site whose members post as and when they can, and usually only if they have something to say.

pmishra · Post by **pmishra** » Mon Sep 01, 2008 7:40 am

ray.wurlod wrote:
pmishra wrote:... but now a new patch named AIX 5.3 ML-07 SP-04. The problem infact came after the new patch installed.

How to avoid stating the bleeding obvious...?

If you want urgent help sign up with your support provider for premium service and learn the true cost of "urgent". DSXchange is an all-volunteer site whose members post as and when they can, and usually only if they have something to say.

I wanted to say, if possible, pls help....... :arrow:

chulett · Post by **chulett** » Mon Sep 01, 2008 8:43 am

Ray's "bleeding obvious" was to uninstall the patch. Hence the quote.

pmishra · Post by **pmishra** » Mon Sep 01, 2008 1:05 pm

chulett wrote:Ray's "bleeding obvious" was to uninstall the patch. Hence the quote. ...

Hi All,

We have ultimately resolved the problem.Actually this problem came after installling the patch. The patch put a constraint on the db server that the user can create max. 32768 number of tables in database. At that time we had 33243 number of tables in db. So we have reduced the no of tables below to 32768 and thereafter the problem gets resolved. And we are able to connect to DB2 Enterprise Stage. :D

Thanx Ray for your comments.

DSXchange