DB2z error

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 12:34 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Jan 13, 2010 3:37 pm

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.

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 3:53 pm

Hey Ray please can you tell what values need to set for DSHOME and APT_RESPATH Actually i have set the DSHOME in under userdefine in administrative client

DSHOME: C:\IBM\InformationServer\Server\DSEngine

chulett · Post by **chulett** » Wed Jan 13, 2010 4:26 pm

Based on your other post I sincerely doubt you should be using that particular stage.

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 4:34 pm

actullay i just testing with remaning all other db2 stages but main issue is with db2 z/os

suneelchallagali · Post by **suneelchallagali** » Thu Jan 14, 2010 4:31 pm

hey please can you help out with setting apt_respath and dshome path so that i can use db2z stage for loading data

ray.wurlod · Post by **ray.wurlod** » Thu Jan 14, 2010 4:51 pm

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

suneelchallagali · Post by **suneelchallagali** » Thu Jan 14, 2010 5:01 pm

I have set the dshome path but how do i need to add database information in dshome path or how do i set APT_respath

ray.wurlod · Post by **ray.wurlod** » Thu Jan 14, 2010 5:22 pm

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.

suneelchallagali · Post by **suneelchallagali** » Thu Jan 14, 2010 5:32 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: ??