DSXchange

Whats the background of this error ? What are you doing in a a job that your are getting this error ?

I haveto put in another post since the form dialog behaves weirdly , did you get any orb trace files created in your import directory when the shell script ran ? Can you try importing individual items for the objects that failed ? Are there any dependent items like parameter sets or shared container...

I created a dsx file ( exported with 'executables' ) and could successfully import it using DSXImportService.sh after ftp to AIX server m/c The 2 jobs were imported in 'compiled' status. I did not find time to create a conf file , i put the command directly like this (I launched it from the dsx expo...

Is modifying RT_STATUS**** & RT_LOGnnnn safe with version 8.x ?

I think so , but does metadata DB/xmeta store anything ( assuming operational metadata is not imported)

Please take a tape and Server disk backup of that entire path - just in case

Can you post the syntax of the DSXImportService command you are using in the script ? Was this working earlier and now it has stopped importing executables ? I presume the export file does contain executables. Are only some executables missed out ?

Murphy's law states that certain issues will only arise in PROD when business needs the data without delay and that the developer has taken a vacation . I assume this has been factored into your design and operations strategy. One example is a data volume issue - you may need to process 40 million r...

Im really concerned if a PROD environment doesn't have a compiler installed , and the operations team need to make a quick fix on a transformer stage issue or a custom operator/build op issue. All environments I have worked have at least a single user compiler license for non Development environments.

Its not wasted time . The best practice is to import jobs and recompile them in the new environment using multiple job compile. Otherwise you will run into design time issues.
Any differences between servers can screw up things.

You also save some time in exporting and importing ONLY job designs.

Tons of excellent tech articles on IBM developer works pages. We are planning to get started with Operations Console at the earliest. We recently installed 8.7 and have completed a tedious migration from 7.51A. Configuration and tuning guidelines for IBM InfoSphere DataStage Operations Console The p...

Thanks everybody.

It took us a while to configure 8.7 ( PAM with Centrify , Migrations, IADB, metadata and IADB & ops consle on SQL 2008 , while engine on AIX - and all that ) . Not looking forward to the effort now . but wanted to get a handle on what we 'missed'

Thanks for posting this . Is this the much awaited " End Of the World " edition ?

Our group installed v 8.7 a couple of months ago due to the end of year deadline for Operating system support. Are there much differences ( apart from hypervisor) ed?

If my source datbase was Oracle 9i or above, I would most certainly use this SQL than do this in datastage transformer loop var Example here that works on any Oracle DB after 10g - substitute your tables columns query instead of inner query . SELECT ROWNUM, START_DATE+ROWNUM-1, END_DATE FROM (select...

Stage Variables in a transformer stage can store values of the previous record. Create a counter . Make sure teh input to the transformer stage is correctly has partitioned and sorted on the columns that you will compare with . I have done something similar using a server job ,and i see no reason wh...

I have seen & faced quite a few issues using the windows slash "\" in the file paths to datasets etc , but not with using the unix style slash "/" even with a Windows based DS Engine.