Search found 31 matches

by abbhi
Wed Apr 29, 2015 5:37 am
Forum: General
Topic: The timezone environment variable TZ is currently not set
Replies: 2
Views: 9612

The timezone environment variable TZ is currently not set

i am getting below message as a info in my parallel jobs. main_program: The timezone environment variable TZ is currently not set in your environment which can lead to significant performance degradation. It is recommended that you set TZ=:/etc/localtime in your environment. Please let me know where...
by abbhi
Tue Apr 07, 2015 3:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: /app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
Replies: 8
Views: 6107

yes this is a new job and the only difference in this and other job is that this is one writing to db2 and other arr reading from db2. Should i try this job using db2 api stage instead of enterprise stage or if you can suggest some other alternative ? All db2 setup has been done correctly on the ser...
by abbhi
Tue Apr 07, 2015 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: /app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
Replies: 8
Views: 6107

I found this entry in /etc/passwd db2adm:x:370:370::/app/DB2Client/DB2V97:/bin/sh we don't have access to login through db2adm id. output of echo $path /app/IBM/InformationServer/Server/PXEngine/bin:/app/IBM/InformationServer/Server/PXEngine/osh_wrappers:/app/IBM/InformationServer/Server/DSEngine/bi...
by abbhi
Tue Apr 07, 2015 1:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: /app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
Replies: 8
Views: 6107

Hi Ajay,

I don't see the file on my datastage server in the specified path ?
Do you need to contact db2 admin related to this.?

The db2 is installed on our datasatge server itself.

Thanks,
Abhishek
by abbhi
Tue Apr 07, 2015 12:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: /app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be
Replies: 8
Views: 6107

/app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be

Hello, I am attempting to write to a DB2 stage and receiving the following error. Below is information to help assess the situation and hopefully resolve the issue. Below is the error i am receiving. /app/DB2Client/DB2V97/sqllib/db2nodes.cfg' must exist and be readable by all users! This is a new jo...
by abbhi
Wed Apr 01, 2015 7:18 pm
Forum: General
Topic: Not able to view jobs in datastage 8.7 Director
Replies: 6
Views: 2173

Hi All,

sorry for the late reply.
The issue has been resolved after deleting the rt_confignnn file and rt_statusnnn file.
After that I was able to compile the job successfully and jobs are visible in director too.

Thank you all for your help.

Abhishek
by abbhi
Thu Mar 05, 2015 6:06 pm
Forum: General
Topic: Not able to view jobs in datastage 8.7 Director
Replies: 6
Views: 2173

Hi Paul,

We already did that option and still issue persists.
by abbhi
Thu Mar 05, 2015 5:17 pm
Forum: General
Topic: Not able to view jobs in datastage 8.7 Director
Replies: 6
Views: 2173

Not able to view jobs in datastage 8.7 Director

Not able to view jobs in datastage 8.7 Director. How ever able to view them in designer client. I am also not able to delete and rename the jobs too. getting error like Cannot open executable job file RT_CCONFIGnnn. Is application restart is required to make director and designer in sync? Please adv...
by abbhi
Sat Jul 26, 2014 12:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel job failing
Replies: 3
Views: 3088

Hi paul,

there is no such file exist ..i dont know where dis coming from..
by abbhi
Fri Jul 25, 2014 12:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel job failing
Replies: 3
Views: 3088

parallel job failing

parallel job getting failed with below errors. OTM_PO_PO_INS_Load,1: Fatal Error: open (read) failed for aptvds1_o1_i1_stno0 in openSeqCommunicator() No such file or directory Sequential_File_0,0: Fatal Error: open (create) failed for aptvds0_o0_i0_stno0 in createSeqCommunicator() Permission denied ...
by abbhi
Wed Jun 25, 2014 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to delete datasets using orchadmin
Replies: 3
Views: 1246

want to delete datasets using orchadmin

want to delete datasets over 3 months using orchadmin

what would be the command ?
by abbhi
Fri Jun 20, 2014 5:02 am
Forum: General
Topic: DataStage Installation on Windows 7
Replies: 4
Views: 2165

Hi,

Thanks for the information.

I am trying to download it from the below link
http://www-01.ibm.com/support/docview.w ... wg24020527

is it the correct one ?
also when im trying to find downloads and media page its asking for site number?
what is that ?

Please help

Thanks for your time :)
by abbhi
Wed Jun 18, 2014 3:52 pm
Forum: General
Topic: DataStage Installation on Windows 7
Replies: 4
Views: 2165

DataStage Installation on Windows 7

Hi All,

Can someone please help me to install datastage on win7.

From where i need to download to software ?

Can someone please help...??
by abbhi
Tue May 13, 2014 12:25 am
Forum: General
Topic: sequence job getting trriggered on its own
Replies: 5
Views: 2655

Hi All,

My issue got resolved. The job was also mistakenly connecting to one other job and getting triggered. We changed it and now its getting triggered as scheduled.

Thanks,
by abbhi
Sun May 11, 2014 9:01 am
Forum: General
Topic: sequence job getting trriggered on its own
Replies: 5
Views: 2655

hi Craig, Thanx for your comments...esp job has been put on hold by the scheduling team on my request to check if the job triggered this time or not. howeve, it get triggered....i dont see any thing in the log that might help you but yes there is one warning coming in one of the parallel job like &q...