Search found 39 matches

by moalik
Mon Mar 24, 2014 2:39 am
Forum: General
Topic: Datastage job Status Code=2
Replies: 8
Views: 7145

Datastage job Status Code=2

Hi, i am using the dsjob command to run my job as below: dsjob -run -jobstatus projectname jobname When ever my job completes with warnings, i am getting the status code =2 and when ever it fails with Fatal Errors, i am getting the status code=2. According to IBM documentation, i should get status_c...
by moalik
Wed Mar 12, 2014 5:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Grid Configuration File issues
Replies: 4
Views: 2378

Regarding Grid Configuration File issues

Hi All, We have created the Grid Configuration on Datastage Engine. I have configured the Master Configuration file as well as project-level configuration file. [abc@XXXXX etc]# cat master_config.apt { // Conductor node entry node "CONDUCTOR" { fastname "ABC Server" pools "c...
by moalik
Tue Oct 08, 2013 6:17 am
Forum: General
Topic: How to find where XMETA is installed from DSEngine on Linux
Replies: 3
Views: 1045

How to find where XMETA is installed from DSEngine on Linux

Hi All,

Could you please let me know, how to find where XMETA is installed from linux.

Any unix command would be very helpful.

Command to show where XMETA is installed, name of the server?

Thanks,
Mohsin Khan
by moalik
Thu Sep 12, 2013 7:20 am
Forum: General
Topic: Minimum Database versions support in Datastage 9.1
Replies: 4
Views: 1916

Hi All,

I found the documentation finally, which tells about the databases versions.

http://pic.dhe.ibm.com/infocenter/prodg ... orm=Linux#

Thanks everyone for your response. :D.
by moalik
Thu Sep 12, 2013 5:43 am
Forum: General
Topic: Minimum Database versions support in Datastage 9.1
Replies: 4
Views: 1916

Thanks for the reply.

I am mainly looking for the connectivity purpose. As i am not a premium member i could you view you complete content.
I tried viewing the release notes for any information,but no luck.

Thanks
by moalik
Thu Sep 12, 2013 4:37 am
Forum: General
Topic: Minimum Database versions support in Datastage 9.1
Replies: 4
Views: 1916

Minimum Database versions support in Datastage 9.1

Hi All, We are planning to upgrade to Datastage 9.1 version and we collecting the information on what are the minimum database versions supported by Datastage 9.1. Could anyone please let us know the minimum versions for the below databases supported by 9.1. 1. Oracle 2. Sql Server 3. DB2 4. Teradat...
by moalik
Wed Jul 24, 2013 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Use of ICONV/OCONV Functions in the Parallel Jobs.
Replies: 7
Views: 9102

Hi Ray/Chulett,

Thanks for the information.
I am really learning most of the things from this forum.

Thanks once again for your time.
by moalik
Wed Jul 24, 2013 7:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Use of ICONV/OCONV Functions in the Parallel Jobs.
Replies: 7
Views: 9102

Regarding Use of ICONV/OCONV Functions in the Parallel Jobs.

Hi All, In many of the date conversions, i have seen the usage of ICONV/OCONV functions as the solutions. But when i am developing a parallel job, we don't have the option of above Functions in Transformer stage, where as in server jobs we have the same in the transformer as well in the sequence jo...
by moalik
Wed Jul 24, 2013 6:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implementing date logic
Replies: 7
Views: 2269

Hi Raji, In DataStage we have a Transform called MONTH.FIRST. This Transform Returns a numeric internal date corresponding to the first day of a month given in MONTH.TAG format (YYYY-MM). Example: MONTH.FIRST("1993-02") => 9164". For your logic Fetch "YYYY-MM" from your inpu...