Search found 32 matches

by rajngt
Fri Dec 28, 2012 6:11 pm
Forum: General
Topic: Failed to open project status code 73
Replies: 3
Views: 2580

The command is dsjob -run -wait -jobstatus -param ps_param1=<value1> -param ps_param2=<value2> -param ps_param3=<value3> -param ps_param4=<value4> <project name> <sequence name> This is called in unix script and this is occuring intermeddiently. Possibly once in 2 weeks. I can find different status ...
by rajngt
Fri Dec 28, 2012 4:10 pm
Forum: General
Topic: Failed to open project status code 73
Replies: 3
Views: 2580

Failed to open project status code 73

Job are failing with error Failed to open project and with status code 73. I have gone through forums and ibm boulder, but not able to find code 73. What this error code means?
by rajngt
Sun Jul 29, 2012 4:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: High disk utilisation in project & DS Engine directory
Replies: 8
Views: 5567

Moving a few projects to different directory is the option which we are evaluating. The data files are not in the project directory. Basically we have two types of job in our projects one set runs for every 15 mins and others are overnight. We are currently set the option to store 4 days of log. As ...
by rajngt
Sat Jul 28, 2012 2:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: High disk utilisation in project & DS Engine directory
Replies: 8
Views: 5567

High disk utilisation in project & DS Engine directory

We are facing high disk utilisation in the project directory /etl/IS/Projects and Engine /opt/IBM/InformationServer/V8.5/ currently there are 28 projects. We are looking into below option to reduce this. 1. Reduce the R/W in project directory. Understand that in project directories due to R/W operat...
by rajngt
Tue Apr 20, 2010 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence slow response
Replies: 1
Views: 1912

Sequence slow response

Hi All,

The sequence kicks off job X, and it is showing waiting for job X to start. The kicked off job finishes in 17 sec but the sequence logs message that job X has started after 5 mins or more. what can be the reason for slow response time

Thanks
by rajngt
Sun Mar 14, 2010 6:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fork function failed
Replies: 6
Views: 4923

i am running the command with user dsadm
by rajngt
Sun Mar 14, 2010 11:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fork function failed
Replies: 6
Views: 4923

still getting the same error
by rajngt
Sun Mar 14, 2010 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fork function failed
Replies: 6
Views: 4923

fork function failed

Hi All, When i try to run the dsjob command from command line it is giving the below error: /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob: 0403-030 The fork function failed. Too many processes already exist. I checked maxproc, it is 4096 and the current no of process running is 63 I checked t...
by rajngt
Mon Oct 26, 2009 4:03 am
Forum: General
Topic: Restrict Admin Users from Importing Jobs into Prod project
Replies: 3
Views: 2296

Mark the project as protected one. Without unprotecting the jobs can't be modified.
by rajngt
Mon Oct 26, 2009 4:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage not starting when oracle path is provided in dsenv
Replies: 3
Views: 3326

Thanks anakumar and Chulett. Now the DataStage is working
by rajngt
Fri Oct 23, 2009 7:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage not starting when oracle path is provided in dsenv
Replies: 3
Views: 3326

DataStage not starting when oracle path is provided in dsenv

We have installed DataStage 7.5.3 and using Oracle 9i as client. In the dsenv file whenever we put LD_LIBRARY_PATH with appropriate path, we are not able to start datastage. DataStage is working when the LD_LIBRARY_PATH is commented in dsenv file and start DataStage. ##Oracle related parameter in ds...
by rajngt
Tue Sep 29, 2009 6:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Count of column which is varchar datatype
Replies: 3
Views: 1888

Re: Count of column which is varchar datatype

use a filter stage to filter-out based on col2 non-null value. then try aggregating
by rajngt
Sat Sep 12, 2009 6:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC.ini File Help
Replies: 8
Views: 18141

this needs to be update if you are trying to connect using ODBC stage otherwise use dsenv file for DB2 connection
by rajngt
Fri Aug 21, 2009 3:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of Robot/CLIENT
Replies: 2
Views: 2049

Re: Abnormal termination of Robot/CLIENT

Check the script log which calls dataStage job and also check the datastage job log, you can conclude why you are getting this error message
by rajngt
Fri Nov 14, 2008 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field 'Emp_code' from input dataset '0' is NULL. Record drop
Replies: 13
Views: 6398

Null field value = ''
change this to Null field value = ' ' (space), try the run now. as you are providing earlier you have provide null value