Search found 16 matches

by vvsaucse
Tue Nov 13, 2012 7:58 am
Forum: General
Topic: Version numbers from all jobs
Replies: 2
Views: 1348

Version numbers from all jobs

Hello - I am working on DS8.5 version mounted on Unix AIX . I would like to know if there is any command to fetch all the jobs and their correpsonding version numbers from command line. Any help is much appreciated.

Regards
Subbu.
by vvsaucse
Thu Sep 13, 2012 9:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Synchronized Commit to MQ of same messages
Replies: 4
Views: 1920

Synchronized Commit to MQ of same messages

Hello - I have a requirement, wherein i am trying to post messages to WMQ. Now for auditing purposes, posting messages to the target Queue and a backup Queue simultaneously (synchonized) has been proposed, where the following needs to be met. Please can you suggest how to achieve this? Requirement :...
by vvsaucse
Tue Jun 07, 2011 9:19 am
Forum: General
Topic: Any Env Variable to Suppress Warnings in DS
Replies: 4
Views: 3164

@Mark,

Yes, thats a possible option, but this job is triggered from CtrlM via unix scripts. so we cannot do that.... Apologies, i havent' mentioned that in the first place.

Cheers
Subbu.
by vvsaucse
Tue Jun 07, 2011 9:10 am
Forum: General
Topic: Any Env Variable to Suppress Warnings in DS
Replies: 4
Views: 3164

Any Env Variable to Suppress Warnings in DS

Hello, My job aborts after 50 Warnings, as per the scheduled default limit, is there an alternative approach, to avoid this, perhaps like addition of an Env Variable, which ignores the same and continues execution even after 50 Warnings? I cannot run the job individually from Director since its trig...
by vvsaucse
Mon Apr 18, 2011 11:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resource Estimates for Scratch and Resource Disk
Replies: 5
Views: 4068

Was trying to use the Resource Estimate option , but getting the below error messages for the same job, which is running to completion with out this option., Would help if anyone can shed some light on the same main_program: Current heap size: 1,554,287,264 bytes in 6,709,915 blocks main_program: Fa...
by vvsaucse
Fri Apr 15, 2011 9:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resource Estimates for Scratch and Resource Disk
Replies: 5
Views: 4068

Can someone please help me out in this?
by vvsaucse
Thu Apr 07, 2011 10:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resource Estimates for Scratch and Resource Disk
Replies: 5
Views: 4068

Resource Estimates for Scratch and Resource Disk

Hello, I am using DS 8.1 Version on Unix (AIX) platform. We have a requirement for a project where in the source and Targets are Sequential files, with transformers, lookups, sort (HASH partition on 4 columns) and Remove Duplicates as intermediate stages. The source is a Fixed width file with 6-8GB ...
by vvsaucse
Thu Mar 17, 2011 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference in Record Count in Sort/Join Stages
Replies: 4
Views: 2975

Yeps. That seems to be the reason. Got it checked. Thnks James.
by vvsaucse
Mon Mar 14, 2011 9:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference in Record Count in Sort/Join Stages
Replies: 4
Views: 2975

@James: Thanks for the quick response. The Left Link has around 10K Records. (Comparitively very less to the reference link) in this particular case. There is no problem with the output as all the Source records have found valid matches in the reference. The partitioning also is as per requirement (...
by vvsaucse
Mon Mar 14, 2011 7:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference in Record Count in Sort/Join Stages
Replies: 4
Views: 2975

Difference in Record Count in Sort/Join Stages

Hi, I am using DS V 8.1 In this, there is a requirement wherein i am using the output of Sort Stage to be provided as the Right Link for Join Stage for an INNER JOIN. When the job is being run, i see that in JOB MONITOR, the output link from Sort is producing 800K rows where as the Inner Join Rec Li...
by vvsaucse
Mon Jan 31, 2011 12:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Loading Data into the Table.
Replies: 1
Views: 1804

Error Loading Data into the Table.

I was trying to load data into a DB2 table when i encountered the below error message. I understand this could possibly be DB Connectivity issue, but not sure why this is coming up now. The volume of data is around 45 Million and almost the same as it has successfully run previously. SQL_ERROR; SQLS...
by vvsaucse
Thu Dec 09, 2010 10:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Processing XML data from Queue
Replies: 1
Views: 1620

Error Processing XML data from Queue

$APT_DEFAULT_TRANSPORT_BLOCK_SIZE = 15242880 $APT_PHYSICAL_DATASET_BLOCK_SIZE = 10464640 The above are the Env variable values used. I am getting a similar error as previously posted. But changing the job now is not an option we have right now. Is there an alternative approach? Below is the Error Me...
by vvsaucse
Fri Sep 10, 2010 6:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Issues for Job Run.
Replies: 6
Views: 2724

Unfortunately, The env(Server) in which the job exists doesnt' have a C++ compiler for transformers and we dont have access privileges to import/export the job again. Is there any other alternative?
by vvsaucse
Fri Sep 10, 2010 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Issues for Job Run.
Replies: 6
Views: 2724

Hi Ray,

The job was compiled and now being executed using DSADM. I assume its having all the necessary privileges being the admin