Udb Connection Problem

[admin]

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users








Hi=20
all,
 
Datastage Px version 7.0
Database - UdbEEE v8.1
OP=20
-- Sun Solaris
 
My=20
problem is when i try to read/view data using  datastage from=20
udb,   I get this error message
 

##I TFCN 000001 13:20:51(000) <main_program>=20
&nbsp;DataStage XE Parallel Extender =
V7.0.0=20
&nbsp;Copyright (C) 2003, 1997 - 2002 Ascential =
Software,=20
Inc. &nbsp;All Rights Reserved =
&nbsp; &nbsp; &nbsp;##I=20
TUTL 000031 13:20:51(001) <main_program> The open files limit is =
100;=20
raising to 65536.&nbsp; ##I TOSH 000002 13:20:51(002) =
<main_program>=20
orchgeneral: loaded&nbsp; ##I TOSH 000002 13:20:51(003) =
<main_program>=20
orchsort: loaded&nbsp; ##I TOSH 000002 13:20:51(004) =
<main_program>=20
orchstats: loaded&nbsp; ##I TFSC 000001 13:20:51(005) =
<main_program> APT=20
configuration file:=20
/apps/Ascential/DataStage/Configurations/default.apt
&nbsp;##W TFPA 000017 13:20:51(006) =
<main_program>=20
Warning: the value of the PWD environment variable =
(/apps/Ascential/Projects)=20
does not appear to be a synonym for the current working directory=20
(/apps/Ascential/Projects/BDW).&nbsp; The current working directory will =
be=20
used, but if your ORCHESTRATE job does not start up correctly, you =
should set=20
your PWD environment variable to a value that will work on all nodes of =
your=20
system.&nbsp; ##W TCOS 000049 13:20:51(007) <main_program> =
Parameter=20
specified but not used in flow: _APT_DBNAME&nbsp; ##W TCOS 000049 =
13:20:51(008)=20
<main_program> Parameter specified but not used in flow:=20
_APT_DB2INSTANCE_HOME&nbsp; ##W TCOS 000049 13:20:51(009) =
<main_program>=20
Parameter specified but not used in flow: _DATA_OUT&nbsp; ##W TCOS =
000049=20
13:20:51(010) <main_program> Parameter specified but not used in =
flow:=20
_DB2PASSWD&nbsp; ##W TCOS 000049 13:20:51(011) <main_program> =
Parameter=20
specified but not used in flow: _DB2QUERYID&nbsp; ##W TCOS 000049 =
13:20:51(012)=20
<main_program> Parameter specified but not used in flow: =
_TGTDB2&nbsp; ##W=20
TCOS 000049 13:20:51(013) <main_program> Parameter specified but =
not used=20
in flow: DSProjectMapName
>##F TUXX 000001 =
13:20:54(000)=20
<main_program> Internal Error: (k =3D=3D numNodes): =
db2partutils.C: 713=20
>Traceback:&nbsp;&nbsp; [6]=20
APT_FatalPath::pureAssertion(0xfe7a9f48, 0xffbec688, 0xffbec6a4, 0x2c9,=20
0xfc42262c, 0xfc42261c), at 0xfe6e9174
>&nbsp; [7]=20
APT_DB2Info::groupNodes(0x2, 0x193848, 0x1a38f0, 0x1a7060, =
>0x1a38f0, 0x194e14), at 0xfc39a1e8 >&nbsp;=20
[8] APT_DB2Utils::getTableDB2NodeMap(0x1a2b70, 0x1a4178, 0xb2660, =
0x19e2b0,=20
0xffbecaf8, 0x194e14), at 0xfc39a84c >&nbsp; [9]=20
APT_DB2ReadOperator::describeOperator(0x194e14, 0xfc444ff0, 0xffbecf2c,=20
0xfc43de64, 0xb24a4, 0x1a38f0), at 0xfc3a4034 =

>&nbsp; [10]=20
APT_OperatorRep::wrapDescribeOperator(0x194e08, 0x0, 0xff0c94dc, =
0xff16f030,=20
0x0, 0x194e08), at 0xfeadfa44 >&nbsp; [11]=20
APT_OperatorRep::check1a(0x194e08, 0x13, 0x1a5f70, 0x13, 0xff16f030,=20
0xffbed4f4), at 0xfeadfe58 >&nbsp; [12]=20
APT_StepRep::sequenceAndCheck1Operators(0x1, 0xac3ec, 0x199400, =
0xff19f1bc,=20
0x194e08, 0x0), at 0xfeb463f4 >&nbsp; [13]=20
APT_StepRep::check(0xac3e0, 0xff19f1bc, 0x0, 0x0, 0x0, 0x129dc0), at =
0xfeb45844=20
>&nbsp; [14] APT_Step::check(0x1299a0, =
0xff16f030,=20
0x1299a0, 0xffbed808, 0xffbed808, 0xffbed808), at 0xfeb3c8e4=20
>&nbsp; [15]=20
APT_OSL::createAndCheckStep(0xad468, 0xffbee930, 0xff383fa4, 0xad468, =
0x2e330,=20
0xffbed894), at 0xff23d4e0 [Babatunde.Ebohon]&nbsp;
Does anyone have idea what could have =
caused=20
this.&nbsp;> =
>
&nbsp;
&nbsp;