DSXchange

To be fair this is one function that can be devilishly hard to find in the manuals since it's not clear which manual it is going to be in! It's something you set in Designer or Manager and use in Director and it also relates to job design, so you could end up searching through four or five manuals i...

So you could perform your delete if your job aborts, a sequence job trigger executes a delete/rollback job that gets passed the process id and table name as a parameter and removes the transactions from that table. Could be used for any table.

You could run the delete as a seperate job and use a row generator (set to 1 row) to create the single delete statement. The Open statement has the error problem and it will try to execute the statement on all nodes, so you are also getting multiple duplicate deletes running at the same time.

There is a modify function called string_trim which is not documented in any DataStage documentation. It does show up in the old Orchestrate manual: stringField= string_trim [ character, direction, justify ]( string ) You can use this function to remove the characters used to pad variable-length str...

I wouldn't go that far. Perfmon is one part of optimisation and tells you whether you are stressing CPU or RAM or whether you are leaving CPU unutilised. Network monitoring and database monitoring can also be used. On top of that you have datastage design decisions to review.

It's a question with a very wide scope. Definitely a lot easier to judge if you had an expert looking at the jobs. You will see some topics coming up a lot in the forum on performance. Hardware, disk drive I/O bottlenecks, network, database, RAM, CPU, too much data, single threaded jobs, poor transf...

No and no. You should be upgrading to 7.5.1a and not 7.5a. You should think about using the new message handler functionality to remove acceptable warning messages from your production job and you should also look at Sequence job check point and restart though it's an optional code change. From memo...

1) In version 7.5, IBM offers improved fault tolerance and high-availability, 24x7 operation through the SOA Editions' clustering support for Oracle, DB2, and SQLServer, reducing project risk by eliminating a single point of failure. This does not seem to be a plus for us since we have a SAN Plus y...

Okay, I thought you were talking about partitioning in a DB2 Enterprise tab, which does have a user id and password option. Tricky one. With a transformer and DB2 partitioining you get three variables when you choose the properties button next to the partitioning type, DB2 Database name, DB2 Instanc...

I hate the way view data doesn't work with the PROJDEF values. You can replace all your PROJDEF values with hard coded values within your job parameters page while you do your development and then change them back to PROJDEF when you are done. It helps to use the copy parameter routine to make this ...

I have had problems importing xml files on AIX 7.5.1A and now just go with DSX. Do a test export and import of one complex job first to see if it works and if all the required stages are installed in your target project.

Have a look at the properties list, you will see a client connection option that you can add that gives you several extra properties such as user id and password. By default the DB2 stage connects to the database using the user id and password of the logged in user, if you add the extra connection p...

This certification hasn't been posted onto the IBM web site yet. We are privilaged to have Ray and his contacts available to give us a preview of the exam description before the official announcement has been made. We may be waiting a few more weeks before the launch.

You could contact your local Ascential support team and ask them to send it to you, if you have a serial number you can get a login to the e.services web site and see if it is available for download under production documentation.

To answer your question the DRS stage should be faster then the ODBC stage as it uses native database connectivity. You will need to install and configure the required database clients on your DataStage server for it to work.