DSXchange

Hi, We are trying to connect to MQ from DataStage using MQ Connector Stage. Till now we have done the following steps: 1> Installed MQ Client on the DS Node. 2> Configured the MQ ( Queue Manager/Dummy Queue etc) We are facing the following problems: 1> [IIS-CONN-WSMQ-000014] Connect to queue manager...

Hi, How will I know whether JObMonApp is running or not. i want to check Programmatically whether JObMonAPp is Running, if it is not running then I need ABORT my BATCH Job. We are using JobMonApP for our Auditing purpose and its very important for us to check whetehr it is running or not before we s...

That's a very easy one. It can't be done with this tool. DataStage is driven by the metadata, not the reverse. Some people elect to create a "generic table definition" with more than enough VarChar columns, but it's not really a satisfactory solution. Hi Ray, So whats the best approach, I...

Hi,

I need to create a generic job which will create metadata for different tables at run time.

My source is DB2 and I need to create table definitions at run time for different tables at run time.

Please let me know how can this be accomplished.

Regards,
- Pavan

You need to do a "reset" of your job and it will put a log entry into your log file that has the title "from previous run". I haven't seen this error message in a simple sequential file read stage before. Are you doing anything non-standard in that stage? Perhaps a filter or a b...

Pavan, What kind of a stage is "readLineItems"? Also do a reset of your job in the director and look at the message "from previous run" to see if additional information is contained in that log entry. This is what is see in director for Previous Run From previous run DataStage J...

Pavan, What kind of a stage is "readLineItems"? Also do a reset of your job in the director and look at the message "from previous run" to see if additional information is contained in that log entry. Hi ArndW, That is name of my link to read a Seqeuential file. where do I get t...

Hi, I am trying to read a sequential file which contains File Header/Doc Header/LIne Item and File Trailer. My Test file contains 12000 records and in my job, iam trying to write into a Hash File, after processing some records iam getting the following message.. Abnormal termination of stage AISVali...

I would recommend going to your backup and doing a clean restore if you can, especially since the cause hasn't been identified yet; it will guarantee a "good" version for your continued use. Just don't forget to make a backup copy of your current (broken) DS just to be 100% certain and sa...

That means that you probably haven't got some catastrophic failure in your projects. The Orchestrate checks aren't necessary yet, since you are having problems communicating with your project. Can you open up an administrator session to your project? Also, you might want to go into TCL as listed ea...

Can you do the following commands from UNIX: cd `cat /.dshome` . ./dsenv bin/dssh LOGTO {YourProjectName} COUNT VOC QUIT This will attach to your DataStage engine home directory, set the environment and enter the the TCL prompt. Then it will do a DataStage level CD to your project and check to see ...

Can you do the following commands from UNIX: cd `cat /.dshome` . ./dsenv bin/dssh LOGTO {YourProjectName} COUNT VOC QUIT This will attach to your DataStage engine home directory, set the environment and enter the the TCL prompt. Then it will do a DataStage level CD to your project and check to see ...

Hi, Is it only to a particular project or to all the projects you have. What happen when you do " orchestrate check "? As Arnd suggested, have you reconfirmed the parameters passed? -Kumar Hi Kumar, It is for all the projects in that server. What is "orchestrate check" We have r...

koolnitz wrote:Pavan,

Try bouncing (stopping and restarting) the DS server, and then connecting to it.

Hi Nitin,

Thanks for responding.
We have tried that option and even we have bounced the Unix Box also.

But it didnt solve the problem.

Regards,
- Pavan

Pavan, there are several possible causes for this, some only minor while others are more severe. What has changed in your installation or happened to the system since you last logged in to the XXX_MI_PROD project? Hi ArndW, THanks for responding. Intially we are facing serious performance problem a...