Search found 14 matches
- Wed Apr 20, 2005 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Better for Surrogate Key Generation? Dstage or DB procedure
- Replies: 1
- Views: 1758
Better for Surrogate Key Generation? Dstage or DB procedure
Hi, Currently I'm having the surrogate key generation logic in datastage. The jobs queries the max Surrogate Key from the database and increments for every new source dimension records. One of my collegue is debating that if we put the surrogate key generation logic into the database stored procedur...
- Wed Apr 13, 2005 3:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connection time out
- Replies: 2
- Views: 1857
DB2 Connection time out
Hi, I'm getting the following error in one of the jobs connecting to Mainframe Db2 database. [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032 This job has 6 lookup sta...
- Mon Dec 13, 2004 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to establish mainframe DB2 connection
- Replies: 0
- Views: 1272
How to establish mainframe DB2 connection
I need DSXChange community's various thoughts about establishing a connection to Mainframe DB2 database. Currently, We are using DB2-UDB API to do this. Is there any other stage/ways to establish this connection, since i heard that DB2-UDB API stage is based server technology? This is first time i'm...
- Fri Aug 20, 2004 11:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Tuning DS server
- Replies: 20
- Views: 11045
Hi, We recently upgraded to DS 7.0.1 from DS 7.0. We also got the same errors (mutex error / Expecting n columns Y columns found). Thanks to Tony's suggestion we turned off row buffering, our jobs ran fine but it is taking long time to complete. Is there any fix so that our jobs will run fine using ...
- Wed Jun 09, 2004 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequencer Not getting the FINISH status from the job
- Replies: 4
- Views: 3850
Sequencer Not getting the FINISH status from the job
One of our sequencer job is waiting even after the job it called finished successfully (i have noticed in some cases, the sequencer finishes after 1 hr). Even though this is happening occassionally, the dw load programs are crossing our batch process window whenever this happens which creates proble...
- Fri May 28, 2004 8:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format checking prior to conversion
- Replies: 3
- Views: 3516
Re: Date
Thanks Guys.
We are using Datastage 7.0 which has the Basic Transformer in PX. But i'm reluctant to use since we are getting some performance issues (sometime fatal errors ). Oracle is the database.
We are using Datastage 7.0 which has the Basic Transformer in PX. But i'm reluctant to use since we are getting some performance issues (sometime fatal errors ). Oracle is the database.
- Thu May 27, 2004 4:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Format checking prior to conversion
- Replies: 3
- Views: 3516
Date Format checking prior to conversion
Is there anyway to check the format of a char column having dates for valid date format prior to conversion ? let me explain within an example. We are getting Date value in various formats (dd-mm-yy, dd-mm-yyyy, yyyymmdd totally about 6 fixed formats ) in a char column. Now the code needs to validat...
- Wed May 12, 2004 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset lookup
- Replies: 1
- Views: 2988
Dataset lookup
Hi, Why the number of the records from Dataset (that gets displayed in monitor window) reference link in a dataset lookup always match the the primary link's number of records ? I created a dataset with 20,000 records in Job X. In Job Y, i use this dataset as a reference link. Primary link has about...
- Thu Apr 15, 2004 7:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "SPARSE" RDBMS lookup.
- Replies: 1
- Views: 2498
Re: "SPARSE" RDBMS lookup.
Documentation says use Spare Lookup whenever the primary source records are very less compared to Lookup (Reference) records.At what kind of situation it is used?
- Thu Apr 08, 2004 2:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Weird PX error when compiling!!!
- Replies: 3
- Views: 3730
Re: Weird PX error when compiling!!!
There are so many posts related to this in this forum. Check them if the following didn't release the job. Log into "DataStage Administrator" and execute following commands. Get the jobno for the job. (SELECT JOBNO FROM DS_JOBS WHERE NAME = 'JobName' ; Then, Administrator -> execute DS.TOO...
- Tue Mar 30, 2004 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Arithmetic
- Replies: 4
- Views: 3373
Date Arithmetic
Hi, How to do Date Arithmetic in Parallel ? Say Incrementing Input Date Fields by 1. When i tried to use DateFromDaysSince i got the following compiler error... ##E TFCP 000007 11:48:30(001) <transform> Error when checking composite operator: Parsing parameters "" for conversion "date...
- Thu Mar 11, 2004 3:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Keeping old job log message
- Replies: 2
- Views: 3517
Keeping old job log message
Hi,
Whenever we overlay an existing job using import, the datastage generated log (Director -> logs) is getting cleaned up. Is there any way (any setting while importing or something similar) to restrict this clean-up on log files ?
Thanks.
Raj.
Whenever we overlay an existing job using import, the datastage generated log (Director -> logs) is getting cleaned up. Is there any way (any setting while importing or something similar) to restrict this clean-up on log files ?
Thanks.
Raj.
- Mon Mar 08, 2004 1:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sort in PX Version 7
- Replies: 5
- Views: 3675
- Wed Feb 11, 2004 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: linking static libraries using parallel routine
- Replies: 8
- Views: 7254
Re: linking static libraries using parallel routine
Hi, When we tried initially, we were also getting this error "Referenced Symbol Not Found". After compiling again with CC (C++) Compiler (Datastage Documentation says the external library should be shared library created by using CC compiler) , the code worked. I'm not sure whether you can...