DB2 Enterprise Stage can't view it's data

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kucica7
Participant
Posts: 1
Joined: Wed Sep 15, 2010 9:29 pm
Location: Indonesia

DB2 Enterprise Stage can't view it's data

Post by kucica7 »

Hi All,

This is my first question on this forum. Anyway, we are trying to read/load data using DB2/UDB Enterprise. We have followed all instruction at http://www.ibm.com/developerworks/data/ ... dm-0609xu/ and everything is run ok. But when we try to view data from DB2/UDB Enterprise, it can't show the data (even the data is available) and give us some messages like this:

##I IIS-DSEE-TFCN-00001 16:20:09(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 16:20:09(001) <main_program> conductor uname: -s=Linux; -r=2.6.18-194.el5; -v=#1 SMP Tue Mar 16 21:52:39 EDT 2010; -n=infosvcdev; -m=x86_64
##I IIS-DSEE-TOSH-00002 16:20:09(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 16:20:09(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 16:20:09(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 16:20:09(005) <main_program> Parameter specified but not used in flow: _APT_DB2INSTANCE_HOME [osl/osl.C:623]
##W IIS-DSEE-TOSH-00049 16:20:09(006) <main_program> Parameter specified but not used in flow: _APT_CONFIG_FILE [osl/osl.C:623]
##I IIS-DSEE-TCOS-00021 16:20:09(007) <main_program> Echo:
db2read
-db_cs UTF-8
-table 'xmeta.acls_2'
-dbname 'xmeta'
-server 'db2inst1'
-client_instance 'xmeta'
-user 'xmeta'
-password '******'

[ident('DB2_UDB_Enterprise_0'); jobmon_ident('DB2_UDB_Enterprise_0')]
0> [modify (
ID:not_nullable int32=ID;
NAME:not_nullable ustring[max=64]=NAME;
CREATE_NAME:not_nullable ustring[max=32]=CREATE_NAME;
CREATE_TIME:nullable int64=CREATE_TIME;
keep
ID,NAME,CREATE_NAME,CREATE_TIME;
)] 'DB2_UDB_Enterprise_0:out.v'
;

eowgenerator -wavelen 100
[ident('_EowGenerator'); jobmon_ident('_EowGenerator')]
0< [] 'DB2_UDB_Enterprise_0:out.v'
0> [] 'DB2_UDB_Enterprise_0:out_EowGenerator.v'
;

...................
...................

FYI, we have 2 different server, that's are 1st for DS Engine (RedHat Linux) and another is for DB2 Storage (RedHat Linux). We also have try to Import plug-in table definition (using Import DSDB2 Meta Data), and it's running ok

I hope there is solutions by this forum.
Many thanks,
Denny
Post Reply