DSXchange

We have DataStage 8.0.1FP1a on UNIX Solaris 10. When my developers run jobs/sequences via control-M using dsjob command I see there are lots of client connection processes (dsapi, dscs) on UNIX. I don't see any client connection in Information Server console. I also see netstat values like ESTABLISH...

I see your point.

The DDLs are exactly same.. The developer exported the dsx as executable. After trying all the debugging and investigations - which took us no where..we exported/imported the design version of the job, compiled in prod and it works... I still don't get it..why only this one job needed to do that way...

You are correct. Each environment has own server.
The ODBC drivers are of the same version.
The entry in .odbc.ini for the connection is also identical except for Oracle source/target server name, SID etc.
Oracle client is also of the same version..

The job runs fine in Dev and Test environment. Today the developer promoted the job in Prod. And gets following error: APT_CombinedOperatorController,0: Fatal Error: [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 63. I searched the posts here, and ...

I tried that...but the output still is almost same without spaces in between the values that I would get from LIST.READU ALL.

XMETALOCKINFO had the user info but I am struggling to connect one of the column to identify what client was used.

So, how do I get the information about locks held by users per project/client type.
My basic purpose of this is to:
1. Manger users per project, leverage budget etc.
2. Capacity planning - user licenses

That is what I did...: >GET.TERM.TYPE xterm terminal emulator (xterm) Width : 80 Depth : 65 Map : ISO8859-1 >SET.TERM.TYPE WIDTH 132 xterm terminal emulator (xterm) >GET.TERM.TYPE xterm terminal emulator (xterm) Width : 132 Depth : 65 Map : ISO8859-1 >LIST.READU ALL Active Record Locks: Device.... I...

You have to forgive my lack of knowledge on uvsh...I just read one of the thread...and tried those things..

http://dsxchange.com/viewtopic.php?t=11 ... e52173009d

Hello, I am trying to get DataStage users logged in into Designer at UVSH. The method I am using is to list the user locks. Problem is that, I am getting only 80 characters in my output which truncates the Item-ID. I want to list the full strings. I read one of the thread that talks about setting up...

if don't want to get into different shells how they export the variables:
. /opt/IBM/InformationServer/Server/DSEngine/dsenv

Just another alternative.

I have DataStage 8.0.1 on UNIX. I am interested in creating a script that can be used by projects to cleanup the environment on a periodic basis. What are the directories that I could include for this cleanup? I am willing to share the script once developed and if someone is interested in. If there ...

I have UNIX DataStage 8.0.1. We have LDAP authentication and we are using OS authentication (UNIX). I am interested in managing user group's role in admin client at command prompt (on UNIX)..like if I give a user developer role and if I want to downgrade the role to operator after 5 days. Currently,...

Basically I have took that from the rc script without using my brain...kind of relying on DataStage folks...

Where can I find the documentation on this?