DSXchange

The program has probably not been compiled. That's why it does not appear in BP.O

Then it needs to be cataloged, but you may have bypassed this by manually creating the VOC entry.

Engine credentials are different, and are set up under the Domain Management menu in the web console.

I guess that's why they specify version 9.7 of DB2 for the DSODB.

You could concatenate them in a downstream Transformer stage. You could create pattern action language to handle $#^ (sharp followed by numeric at the end of the line) but this would need to be in your copy of the MNS rule set, not the out-of-the-box one. You could perhaps create an input pattern ov...

It's the database management configuration file. You'll need to discuss with DBA. It's in DB2, not in DataStage.

Not entirely true. Though they were developed with parallel jobs in mind, you'll find that you can use Data Connections, Parameter Sets and Connector stage types in server jobs also.

Set umask to 0022 before creating the new project. And even then you may need to change the group associated with the project directory and everything in it, using a recursive (-R) chgrp command.

Not using roles. In your future there is a Super Operator role, which behaves exactly as you describe. You can probably use file system permissions, for example making DS_JOBS and DS_JOBOBJECTS read-only for that user. (Actually it might be worth checking whether the Super Operator role was back por...

Note that the RESIZE syntax Arnd gave relates to hashed files for which a VOC entry exists, and can be improved upon. Assuming that there is a VOC entry, prefer RESIZE {filename} * * * 64BIT USING {pathname} where pathname is a directory on a separate file system that has sufficient space to make a ...

What permission does dsadm have to the parent directory in which you are seeking to create the project directory?

What value does dsadm's umask setting have?

You will see a minor degradation, as data in server jobs have to transition through a conversion layer in order to execute in the Information Server parallel execution environment.

Are your Engine credentials correct?

Do you know what dsrpc error 80011 means?

StringToDate() requires a format string that exactly matches the format in which the date is contained within your string. So does DateToString() to get the date into a different format. Even the delimiter characters have to be correct.

Short answer is yes. The tool you use depends on the exact version of Information Server you are using and which database you are using for your repository. For example version 8.7 allows you to quiesce the database and provides "complete" backup/restore utilities.