Page 1 of 1
Unable to connect DB2 Server via DB2 Enterprise Stage
Posted: Sat Aug 30, 2008 5:32 am
by pmishra
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
Posted: Sat Aug 30, 2008 7:59 am
by chulett
Welcome! :D
Is this the same problem as posted here?
http://www.dsxchange.com/viewtopic.php?t=121802
Unable to connect DB2 Server via DB2 Enterprise Stage
Posted: Mon Sep 01, 2008 6:17 am
by pmishra
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
Re: Unable to connect DB2 Server via DB2 Enterprise Stage
Posted: Mon Sep 01, 2008 6:39 am
by ray.wurlod
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.
Re: Unable to connect DB2 Server via DB2 Enterprise Stage
Posted: Mon Sep 01, 2008 7:40 am
by pmishra
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.......
Posted: Mon Sep 01, 2008 8:43 am
by chulett
Ray's "bleeding obvious" was to uninstall the patch. Hence the quote.
Unable to connect DB2 Server via DB2 Enterprise Stage
Posted: Mon Sep 01, 2008 1:05 pm
by pmishra
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.