Search found 31 matches
- Fri Jan 23, 2009 10:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ulimit -a shows different with the same id
- Replies: 17
- Views: 12023
- Wed Jan 09, 2008 4:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage DB2 Enterprise Edition Error
- Replies: 5
- Views: 4178
- Tue Jan 08, 2008 11:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage DB2 Enterprise Edition Error
- Replies: 5
- Views: 4178
Just wondering if you found a solution. I ran into the same issue. We are using DB2 client v8 on the DataStage server and DB2 V9 on the database server. We are able to use both ODBC and DB2/API to query from DB2 V9 but DB2 Enterprise stage aborted with the same error. My next attempt would be instal...
- Mon Feb 12, 2007 1:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: I-descriptor was not compiled
- Replies: 15
- Views: 8038
- Wed Feb 07, 2007 10:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: I-descriptor was not compiled
- Replies: 15
- Views: 8038
Thanks for saving me some work. Just getting ready to add the filter below and found your latest reply. Ran the new code multiple times today against the largest project and the error has not occured. Will continue to monitor the jobs for a few more days.
Code: Select all
WHERE CAST(@ID AS VARCHAR) NOT LIKE '//%'
- Wed Feb 07, 2007 2:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: I-descriptor was not compiled
- Replies: 15
- Views: 8038
- Wed Feb 07, 2007 1:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: I-descriptor was not compiled
- Replies: 15
- Views: 8038
- Wed Feb 07, 2007 1:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: I-descriptor was not compiled
- Replies: 15
- Views: 8038
Thanks for the quick response. The job is scheduled to run at 6:00 everyday on all DataStage servers. It usually fails on Sunday morning and on large (500+ jobs) projects. I have not been able to establish a pattern and will continue to track this. As far as using the UNNEST to normalize FULL.TEXT, ...
- Tue Feb 06, 2007 5:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: I-descriptor was not compiled
- Replies: 15
- Views: 8038
I-descriptor was not compiled
I would like to get a list of log entries for a job which were generated after a point in time. I am using a UNIVERSE stage with the below SQL. SELECT @ID, "TYPE", TIMESTAMP, EVAL "FULL.TEXT[1,8]", EVAL "@RECORD<7>" FROM UNNEST RT_LOG2547 ON FULL.TEXT WHERE @ID >= 0 AND...
- Mon Feb 05, 2007 12:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Database name included in SQL in ODBC stage
- Replies: 7
- Views: 3362
hi rdsarbo, i had the same problem for which i used user defined environment variables as parameters and this works good . thanks, abhi. Anhi - Can you elaborate on the variables and what you did? We are facing the same problem. When importing table defs via ODBC, the entries are fully qualified an...
- Mon Jul 10, 2006 1:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Capturing rejected rows from DB2/UDB API Stage
- Replies: 1
- Views: 1563
Capturing rejected rows from DB2/UDB API Stage
We are having problem capturing rows that are not loaded to the DB2 mainframe using the DB2/UDB API stage in a PX job. Here is the basic job design. Seq ---> Transform ---> DB2/UDB API | V Seq2 In the transform, we added an "OTHERWISE" contraint and chhecked the "Otherwise/Log" b...
- Wed Jun 28, 2006 5:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem while loading date into a table
- Replies: 4
- Views: 2247
The TZ environment variable needs to be set to GMT
Technical Support acknowledged that this is a known issue. The workaround was to set TZ=GMT. Once this was set, the correct date was inserted into the Db2 table.
Thanks
Thanks
- Wed Jun 28, 2006 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem while loading date into a table
- Replies: 4
- Views: 2247
one day less
I am experiencing the same issue and wondering if there is an explanation. I have the following PX job: seq --> xfm --> DB2/UDB API There is a date field in the incomoing data with YYYY-MM-DD format. The coressponding field in the DB2 database is of type Date. In the tranform stage, I am using the S...
- Fri Jun 23, 2006 9:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2/UDB Load Issues
- Replies: 4
- Views: 3054
Re: DB2/UDB Load Issues
Klaus,
Thanks for confirming this. Not what I wanted to hear but oh well. It looks like DB2/UDB API is the only stage that is working for DB2 on a mainframe.
Thanks for confirming this. Not what I wanted to hear but oh well. It looks like DB2/UDB API is the only stage that is working for DB2 on a mainframe.
- Thu Jun 22, 2006 11:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2/UDB Load Issues
- Replies: 4
- Views: 3054
DB2/UDB Load Issues
Our environment: DataStage 7.5 on AIX DB2 Connect Version 8 DB2 Database V7 on Z/OS The DB2/UDB Load stage does not work. The error message returned was " SQL1325N The remote database environment does not support the command or one of the command options. " The DB2/UDB Load Stage documenta...