I am getting the following error:
main_program: Fatal Error: APT_DB2Utils::dbversion:unrecognized version string: `SQL09053'.
This started happening after we upgraded our DB2 (on AIX) from 8.1 to 9.5. We are using DataStage (ver 7.5.2) and the error occurs only when using the DB2 Enterprise Stage.
Search found 7 matches
- Thu Apr 16, 2009 12:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error connecting to DB2 version 9.5
- Replies: 0
- Views: 1251
- Wed Feb 20, 2008 1:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Why suddenly longer startup times?
- Replies: 2
- Views: 1912
Why suddenly longer startup times?
For the past several days the startup time on many of our jobs has increased from approx. 30 seconds to over 2 minutes. We are, of course, trying to find out why. DBA, Unix Admins, network admins and ETL programmers all state that no changes have been made to the system. On suggestion from IBM is to...
- Wed Jun 20, 2007 10:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to run job --2
- Replies: 5
- Views: 4010
Getting same error message
I was getting the same uninformative error message in our job tonight: "ODBCTORURLOGSUM, 0:Unable to run job --2" The ODBCTORURLOGSUM refers to the name of a container stage that includes an ODBC stage used to update data in a SQL server table. We are using the container stage to incorpora...
- Thu Jul 27, 2006 10:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify to "truncate" timestamp
- Replies: 6
- Views: 3791
- Thu Jul 27, 2006 10:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Modify to "truncate" timestamp
- Replies: 6
- Views: 3791
Modify to "truncate" timestamp
I have a need to drop the time portion of a timestamp and store the data back into a timestamp field. The result basically changing the time portion to 00:00:00 Ive tried the following: trans_dt = Timestamp_From_date(Date_From_Timestamp(tdatetime)) but am receiving the following error: main_program:...
- Thu Jul 27, 2006 6:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Arithmetic with Modify Stage?
- Replies: 3
- Views: 2264
Arithmetic with Modify Stage?
Can a modify stage be used to add or subtract two fields together into a new value? I'm getting the following error: main_program: Error parsing modify adapter: Expected ';' or end, got: "-"; input: trans_dt = trans_dt ; store_nbr = storenum ; wrkstatn_nbr = wrkstanum ; store_id = storenum...
- Wed Jul 26, 2006 11:00 pm
- Forum: Site/Forum
- Topic: Video Tech Tip Series - FEEDBACK
- Replies: 49
- Views: 134158
Modify Question
I'm not sure this is the right forum for this post so let me know if not. Can a modify stage be used to add or subtract two fields together into a new value? I'm getting the following error: main_program: Error parsing modify adapter: Expected ';' or end, got: "-"; input: trans_dt = trans_...