DSXchange

Sorry, I don't think we do.

Brad.

Was this ever resolved? Are you loading to a DPF database (partitioned database, that is)? What stage are you using? is it a local database (i.e. exists on the same nodes as your ETL nodes in the APT_CONFIG_FILE) or a remote database? If it is a remote database, the DataStage framework needs to be i...

Just want to see if I am understanding the concept: So if your machine has 8 CPUs, you could define 8 ETL nodes in your APT_CONFIG_FILE (not that they are 'assigned' to a CPU). If you are not overloading your CPUs, you could conceivably define more ETL nodes than you have CPUs. Is that right? Thanks...

I found another entry the designated an alternate server, right after the hostname entry:
Hope this helps.

Brad.

We have several different Oracle sources here and are using DataDirect Oracle Wire Protocol: [OUR_ORA_SERVER] Driver=/opt/IBM/dev/InformationServer/Server/branded_odbc/lib/VMora23.so Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDesc...

Workaround - create multiple DS jobs that accept 0, 1, 2, or 3 sort columns. What a pain... more jobs to maintain. Question - will DataStage ever be upgraded to accomodate a varying number of fields for sorts, joins, merges, etc? We can parameterize the field names themselves, but cannot alter the n...

ARRGGHHHH. The Teradata incident was to fix the error messaging, not to fix the problem. The RDBMS code 2113 is the default code when an error occurs and there is no specific error message to display. We are now going to open our own incident with Teradata and see if we can convert it into an RFC an...

I have a job that is writing large volumes to a remote DB2 (UDB) database. The DataStage framework has been installed on the target database nodes and we have been able to do some preliminary loads to the database. Job is: TDConnector (read) -> DB2EntStage (load) I have added a sort stage to the job...

We worked with Tom O'Shea (DSXChange user toshea), a resource at IBM, that gave us the following information: Unfortunately, the error messages from the TPT export operator are rather poor. Teradata claims to have better error messages in Teradata 13. You guys actually ran into this problem years ag...

Thanks, I took a look. Where do I find the option to turn off the logic push to the source? Not sure if it will help or not. It seems to be referring to pushing DS-internal sorts to the database, and this is a SQL with a sort in it already.

Brad.

I have a job that reads from Teradata and writes to DB2. We pass in the table name, an optional where clause and an optional order by clause. It is failing: Teradata_Table_Read,0: RDBMS code 2113: libexportop.so) instance(1): INITIATE method failed with status = Fatal Error SQL statement: LOCK ROW F...

We had a question from another administrator about what permissions DBA provides and if it is too much privilege for the average developer. He experimented and removed DBA from his own I'd and was able to updated and compile jobs. So, what does DBA do? Is it an admin-level permission or do all devel...

Never mind, did the FIX anyway (hey, it's my own project, so if I screw it up, it doesn't affect anyone else :) ). Looks like that was the right thing to do based on the results >VERIFY.SQL SCHEMA carlb04 FIX Checking permission. * '/u001/dev/Ascential/DataStage/Projects/carlb04' is not a DataStage ...

Okay, had the wrong syntax (correct syntax: DataStage projects ). Forgot the SCHEMA keyword and got some better info: >VERIFY.SQL SCHEMA carlb04 Checking permission. * '/u001/dev/Ascential/DataStage/Projects/carlb04' is not a DataStage account. * Data for the schema 'carlb04' should be deleted. 2 fi...

We recently had to recover 75-100 DataStage 7.5 projects on our development system. I am working through a number of other issues, and was searching for anything related to VERIFY.SQL. I came across a posting that suggested doing a VERIFY.SQL ALL to validate projects ( Error adding project ). On a w...