DSXchange

Universe will remain as the DataStage Engine.....A new database instance (e.g., Oracle, DB2, SQL Server) will be created to hold Job related metadata such as Job designs, Routines and so on.

Well if you are trying to delet ea hash file outside of the Project in another location (no VOC entry exists) then you can simply delete them from operating system with your command of choice. But if your hash files are located in the Project...is this true? Then you need to go to Administrator comm...

If you have DS 7.5 and above use the Stored Procedure Stage or you can write a Routine. I don't believe the OCI Stage supports.

Use the Notification Stage in the Sequencer

You may want to checkout DataStage TX as a possibility

No one will ever answer this type of questions......sounds like you need experience and education

Well by default the uv command (which you need to execute in order to reindex in the first place) has the following permissions:

-rwsr-x--x 1 root dsadm 61440 Jun 2 2004 uv

So you need execute on the group and other

chulett is correct with the answer. But may I add that restarting the server is so drastic of a solution.....go to your DataStage Administrator who has the option to unlock and remove processes before you restart...

Sounds like the Unix account for the host and DataStage Project is not correct or doesn't belong to the proper Unix Primary Group....

Well first to install DataStage Client you need Admin rights so you mus have had it even for Multi-Client Manager....DataStage install quickly tells you you don;t have Admin rights.... But barring that I would say your Windows Registry (regedit at command line) needs to delete Ascential in the Softw...

Sure, FTP Stage is available and if its got a IP Address, logon and password then it can be FTP'd

Sounds like you have more columns than defined to me for those rows or more than likely the delimiters for those rows have an issue throwing the columns off

Well, I believe your DataStage Project requires reindexing:

Make sure all individuals are logged out of [name of the Project]

cd DataStage home path

Logon as the DataStage Administrator
. ./dsenv
bin/dssh
LOGTO [name of the Project]
DS.REINDEX ALL
QUIT

Yes, DataStage can create a Server Job, Parallel Job, MVS Job and a "Real-Time Job". You need to install RTI (Real Time Integration) product. You can purchase this or purchase DataStage SOA which gives you DataStage EE and RTI. You also need to install the Web Services Pack. So now what ha...

Well Ray's comment is correct...But if you dare ignore and want to UNLOCK then perform these before UNLOCK....

SET.FILE UV VOC UV.VOC
COPY FROM UV.VOC TO VOC UNLOCK

I presume your not going through DSTools but doing it the "command" way which creates your error....