DB2z error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
DB2z error
Hi,
I am reading the data from db2 database which is on main frames using db2z/os stage in datastage 8.1 before runnnig the job when i have entered valid user_name,password and database name and trying to view data i am getting the below error
##I IIS-DSEE-TFCN-00001 13:27:27(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.4987
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 13:27:27(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=NSADS-DEV2; -m=Pentium
##I IIS-DSEE-TOSH-00002 13:27:27(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 13:27:27(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 13:27:27(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 13:27:27(005) <main_program> Parameter specified but not used in flow: _DSHOME
##W IIS-DSEE-TOSH-00049 13:27:27(006) <main_program> Parameter specified but not used in flow: _APT_DISABLE_COMBINATION
##W IIS-DSEE-TOSH-00049 13:27:27(007) <main_program> Parameter specified but not used in flow: DSProjectMapName
Resource bundle corresponding to message key Error while attempting to connect to DB2. not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key dbname = abc not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key userid = Tdef not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key password <not-printed> not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key SQLCODE = -332 not found! Check that DSHOME or APT_RESPATH is set.
>##F IIS-XXXX-XXXX-00000 13:27:27(008) <main_program> Fatal Error: ??
please help me out with this issue
thank you
I am reading the data from db2 database which is on main frames using db2z/os stage in datastage 8.1 before runnnig the job when i have entered valid user_name,password and database name and trying to view data i am getting the below error
##I IIS-DSEE-TFCN-00001 13:27:27(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.4987
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 13:27:27(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=NSADS-DEV2; -m=Pentium
##I IIS-DSEE-TOSH-00002 13:27:27(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 13:27:27(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 13:27:27(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 13:27:27(005) <main_program> Parameter specified but not used in flow: _DSHOME
##W IIS-DSEE-TOSH-00049 13:27:27(006) <main_program> Parameter specified but not used in flow: _APT_DISABLE_COMBINATION
##W IIS-DSEE-TOSH-00049 13:27:27(007) <main_program> Parameter specified but not used in flow: DSProjectMapName
Resource bundle corresponding to message key Error while attempting to connect to DB2. not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key dbname = abc not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key userid = Tdef not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key password <not-printed> not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key SQLCODE = -332 not found! Check that DSHOME or APT_RESPATH is set.
>##F IIS-XXXX-XXXX-00000 13:27:27(008) <main_program> Fatal Error: ??
please help me out with this issue
thank you
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are two errors here. One is that DSHOME or APT_RESPATH environment variables are not set, so that DataStage can not retrieve the text associated with the error. This is easily fixed.
The second, for now, is "??". Once the first has been fixed there may be some useful information there but, for now, there isn't and this precludes sensible diagnosis.
The second, for now, is "??". Once the first has been fixed there may be some useful information there but, for now, there isn't and this precludes sensible diagnosis.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
Based on your other post I sincerely doubt you should be using that particular stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DSHOME is the location of your DataStage server engine. For example (if you installed in the default location on X: drive):
Code: Select all
X:\IBM\InformationServer\Server\Engine
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Setting DSHOME should be sufficient.
APT_RESPATH has a fixed relationship with DSHOME if default locations were used for installation.
Being Windows, you may need to re-boot for the change to environment variable value actually to take effect.
APT_RESPATH has a fixed relationship with DSHOME if default locations were used for installation.
Being Windows, you may need to re-boot for the change to environment variable value actually to take effect.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
I have set the dshome path = c:\IBM\InformationServer\Server\Engine in datastage administrator and i am trying to view the data from db2z stage i am getting below error:
##I IIS-DSEE-TFCN-00006 18:29:55(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=NSADS-DEV2; -m=Pentium
##I IIS-DSEE-TOSH-00002 18:29:55(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 18:29:55(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 18:29:55(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 18:29:56(000) <main_program> Parameter specified but not used in flow: _DSHOME
##W IIS-DSEE-TOSH-00049 18:29:56(001) <main_program> Parameter specified but not used in flow: _APT_DISABLE_COMBINATION
##W IIS-DSEE-TOSH-00049 18:29:56(002) <main_program> Parameter specified but not used in flow: DSProjectMapName
Resource bundle corresponding to message key Error while attempting to connect to DB2. not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key dbname = USTSYITA0D not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key userid = TLCCADEV not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key password <not-printed> not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key SQLCODE = -332 not found! Check that DSHOME or APT_RESPATH is set.
>##F IIS-XXXX-XXXX-00000 18:29:56(003) <main_program> Fatal Error: ??
##I IIS-DSEE-TFCN-00006 18:29:55(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=NSADS-DEV2; -m=Pentium
##I IIS-DSEE-TOSH-00002 18:29:55(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 18:29:55(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 18:29:55(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 18:29:56(000) <main_program> Parameter specified but not used in flow: _DSHOME
##W IIS-DSEE-TOSH-00049 18:29:56(001) <main_program> Parameter specified but not used in flow: _APT_DISABLE_COMBINATION
##W IIS-DSEE-TOSH-00049 18:29:56(002) <main_program> Parameter specified but not used in flow: DSProjectMapName
Resource bundle corresponding to message key Error while attempting to connect to DB2. not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key dbname = USTSYITA0D not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key userid = TLCCADEV not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key password <not-printed> not found! Check that DSHOME or APT_RESPATH is set.
Resource bundle corresponding to message key SQLCODE = -332 not found! Check that DSHOME or APT_RESPATH is set.
>##F IIS-XXXX-XXXX-00000 18:29:56(003) <main_program> Fatal Error: ??