DSXchange

Thanks for the commands Ray.

So we need to execute all the above insert statements, right?

What do you mean by Thanks

Tried same result. 1 record

How can we find the person who did this?


Please show us how to re-build these metadata manually.

Thanks alot

we have around 1400 jobs in one of our project and trying to get the list of jobs and their modification times, we are querying the DS_AUDIT table for each project. LIST.DICT DS_AUDIT The command ONLY returns 1 records listed. Also ran this command SELECT * FROM DS_AUDIT WHERE CLASS = '2' Result - D...

Permissions are 775 and dsadm can write in that directory.

we do not have dstmp file in the path you mentioned. we use dsadm to stop and start datastage services

we do not have any TEMP variable set in our Environment.

jdmiceli wrote:Hi Bryceson,

The Administrator from our company said he was going to post it up somewhere, but I haven't seen it either. I know there is more going on yet though, because the problem still is not fixed.

:(

Hi John,
do you have the patch details that were applied on your system?

Hi , After we bounce DS Server we get this warning message. chmod: WARNING: can't access /dir1/Ascential/DataStage/DSEngine/dstmp.090128.144007A /dir1/Ascential/DataStage/DSEngine/sample/ds.rc: /dir1/Ascential/DataStage/DSEngine/dstmp.090128.144007A: cannot open DataStage Engine 7.5.3.1 instance &qu...

[quote="Mike"]Unique key violation... you attempted to insert rows with the same key from different processing nodes. The message is telling you to change the commit interval to 1. Doing so will result in one processing node inserting the row and the other processing node updating the row....

[quote="kandyshandy"]Warning or Fatal?

In the UPSERT mode, did you specify sub property "Insert Array size = 1"?[/quote]
-Warning
-no array size is defined in sub property

we are loading a seq file to db2 stage using upsert method and getting this warning message in db2 stage
[code]
Failure. Error code SQL0803N. Execute array one element at the time.
[/code]
what does this warning message means. Please advise as we are getting alot of them.

Thanks

How to check if we have a secondary index on a hashed file?

I need to recycle DataStage Server but there is one Established connection which I am unable to kill. bin/uv -admin -info shows no DataStage process DS-TOOLS shows no locks or active semaphores ipcs command shows no memory shared segments But when I execute netstat -an|grep 31538, there is one estab...

Hi All, we are installing DS 7.5.3 on Solaris 10 and the installation hangs at this point Unpacking support libraries - ERROR: cannot unpack libdslic.so Excerpt from dsinstall log file - First run cpio: Bad magic number/header. 1 errors Excerpt from dsinstall log file - Second run cpio: Can't read i...