DSXchange

If you have enabled the Check Point restart option you can just rerun . So that the job will start at the last check point. Look at the Job properties tab in your Sequence. Search for the same. Also you need to enable Restartability for the project from Datastage Administrator- It is in the Propert...

Hi There is a big problem now. I cannot log in to datastage- so user can except "dsadm" Everyone of us is getting this message: Record 24A04DDC-CF1C-4755-8909-84F869FD7B71-AWGD-N2496:168042 on file 29 cannot be written This comes with my existing problem of logging to the Administrator whi...

Heh Guys

I found it out....

You need to give 30 seconds interval atleast after stopping and starting the Datastage Server...

WOW..........

ArndW wrote:Have you tried to create dummy project on the system to if the errors disappear?

I can create project using "dsadmin" id. But cannot login with any other user-id to Datastage administrator.
What can be the problem?

Hi I am setting up the Unix groups for my organization- we are implementing Datastage for the first time. I wanted some input on this. Also this is how I plan to setup the user. First I have a etl level admin id. User id : etladm Id desc: this is the owner of all the Unix level directories for ETL g...

Yes. You can also use the Datastage administrator and from the Command Line run the "LIST.READU "

That would give you all the users logged in.

What is specificly happening- I guess it is the performance of delete - but you are talking of 1000 records which is really less in volume. Doing a delete is ofcourse slow as it works on row by row. If you have audit columns - I mean a Create Date and Modified Date in all your target tables then you...

Thanks for all your suggestions. All the projects that I have worked used AIX or Solaris i.e. UNIX based server for DataStage. Now my boss is asking me a question: Why we do not use a Windows Server for DataStage implementation. What is the advantage of Datastage on UNIX over DataStage on Windows. W...

Hi Before going to the question I want to provide some details of our present system architecture- Now we have some questions as we plan to buy new AIX servers for test and production environments for our ETL codes (Datastage and Business Objects). Previously we had AS400 machines handling all IT sy...

Hi In our organization the database is in DB2 for AS400 ( iSeries). The Datastage server is in Unix. It connects to the DB2 AS400 via gateway or better known as DB2 connect. I have a question on an issue- Now IP addresses on all of our iSeries partitions are going to change soon, but the DNS names w...

Hi I am designing the automation process of my project- In this process there is a Unix daemon process. All the time this Unix process would be running with 10 minute sleep. the process would trigger a shell which runs the datastage job using a dsjob -run. Here I am implementing File watcher concept...

Hi Panic :D First thing - do you know what character you are having. What you see as special character in your Editor is not the true identifier of what is coming in data...If you are sure of the special chatacer- Then yes, you can do a field level modification by using TRIM Use TRIM( linkname.colum...

Make sure your source your dsenv file as part of your script. Thanks a lot- Ray and Bland- I fixed the code. I modified the code a bit and made it much simpler. I am mailing the scripts, please suggest some improvements . It might help others too. #!/bin/ksh ########################################...

Hi These are some pointers- we need to design the configuarion file for dividing the data into partitions(depending on the logic) and using the concept of parallelism in a Datastage job. Also you need to designa nd allocate appropriate space for resource disk and scratch disk in your configuration f...

Hi I have created a shell script to Execute Datastage job but I am getting thos error while executing it. Could not load program /appl/ascential/Ascential/DataStage/DSEngine/bin/dsjob: Dependent module libvmdsapi.so could not be loaded. Could not load module libvmdsapi.so. Please suggest what to do ...