Search found 303 matches

by JPalatianos
Wed Mar 07, 2012 7:40 am
Forum: General
Topic: Problem Deleting Job
Replies: 9
Views: 2698

I ran DS.REINDEX ALL on the project thinking that may help and now face: The same issue where it says the job still exists while trying to reimpot and the new issue.....In Director under the "STATUS" view I see no folders only the root folder for this project "CFF" with nothing u...
by JPalatianos
Wed Mar 07, 2012 6:53 am
Forum: General
Topic: Problem Deleting Job
Replies: 9
Views: 2698

Problem Deleting Job

Hi,
We had one of our developers delete jobs and when I import jobs from a backup it indicates that one of teh jobs is still present. I do not see it in designer but see it in Director and it has been moved to the root folder of the project. How can I remove or clean this up?
Thanks - - John
by JPalatianos
Mon Feb 27, 2012 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UDB error trying to do an Update
Replies: 1
Views: 953

After looking at the job and database for the developer I realized that the issue was he was using an outdated Table definition for his metadata.
This isssue has been resolved.
Thanks - - John
by JPalatianos
Fri Feb 24, 2012 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UDB error trying to do an Update
Replies: 1
Views: 953

UDB error trying to do an Update

Hi, We have a job that has one ODBC as input a transformer and then 2 ODBC's as output and 1 DB2_UDB_API as output. Th columns bein fed to the failing stage are CNTR_NO char(6) and CNTR_LENGTH Integer. The job is failing on the DB2_UDB_API stage with: DB2_UDB_API_63,0: Warning: GPFRI_CNTRCT_RULE_002...
by JPalatianos
Thu Jan 19, 2012 8:56 pm
Forum: General
Topic: Version 8.5 vs 8.7
Replies: 3
Views: 1621

I appreciate the feedback. We rae leaning towards 8.7 as well.
Thank You - - John
by JPalatianos
Wed Jan 18, 2012 7:38 am
Forum: General
Topic: Version 8.5 vs 8.7
Replies: 3
Views: 1621

Version 8.5 vs 8.7

Hi, We are implementing Business Glossary and MetaData Workbench in our shop in the next few months and in order to take advantage of all the functionality we need to upgrade from Version 8.0 to 8.5. Now that 8.7 has been released I was curious if anyone has any experience/thoughts regarding issues/...
by JPalatianos
Mon Oct 17, 2011 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Question on DSAPI.h
Replies: 2
Views: 2982

Thanks Ray... This may be outside the scope of this forum, but I figured I would give it a shot. Here goes the notes from one of our developers on the specific error he receives. Thanks - - John I have marked my comments in magenta in the main() function below. The API call DSGetJobInfo(hJob,DSJ_STA...
by JPalatianos
Fri Oct 14, 2011 11:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Question on DSAPI.h
Replies: 2
Views: 2982

Question on DSAPI.h

Hi, We are staring to create some extrrenal C++ jobs for auditing purposes but have recently noticed a discrepancy between our DSAPI.h file and what was listed in the documnetation. Specifically the structure _DSJOBINFO, We are running version 8.0.1 FP3 and the create date on the DSAPI.h is Thursday...
by JPalatianos
Fri Sep 16, 2011 8:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start ORCHESTRATE job
Replies: 7
Views: 3563

hi,
Per IBM we have appled an upgrade to our MKS toolkit (Via patch supplied to us by IBM) and 2 weeks later it seems to have taken care of our orchestrate issues.
Thanks - - John
by JPalatianos
Mon Aug 22, 2011 1:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start ORCHESTRATE job
Replies: 7
Views: 3563

The latest on this issue.....IBM has narrowed the problem to the MKS toolkit. They had us generate many logs for them to analyze and they should be getting back to us with a resolution.
by JPalatianos
Wed Jun 22, 2011 11:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start ORCHESTRATE job
Replies: 7
Views: 3563

IBM just got back with the following: 1) Patch being created to backport the environment variables - APT_PM_PLAYER_CONNECT_TIMEOUT, APT_PM_PLAYER_TIMEOUT - which will let the system keep running jobs even though it is overloaded 2) Get ETA for patch 3) Setup conference call with Prudential to explai...
by JPalatianos
Wed Jun 22, 2011 8:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start ORCHESTRATE job
Replies: 7
Views: 3563

Mike,
Thank you for that information. I will let IBM know and see what they come back with.
Thanks - - John
by JPalatianos
Tue Jun 21, 2011 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start ORCHESTRATE job
Replies: 7
Views: 3563

Unable to start ORCHESTRATE job

Hi, A few months back we had many of our parallel jobs just hanging on the OSH script (...) step. We opened a PMR with IBM and they suggested to install Fix Pack 3 We were running version 8.0.1 Fix Pack 1. We installed Fix Pack3 and we are now receiving the following error(for the past month) main_p...
by JPalatianos
Fri Jun 03, 2011 4:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: padstring issue while loading into Netezza Database
Replies: 7
Views: 3237

The default value for APT_STRING_PADCHAR is low values 0x0. If you want to cahnge this to spaces just delete the 0x0 and replace with a single space in Administrator.

- - John
by JPalatianos
Fri Jun 03, 2011 1:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_PM_CONDUCTOR_TIMEOUT and APT_PM_NODE_TIMEOUT
Replies: 8
Views: 7317

What you have posted is corrcet. We have just implemented the two in our shop as it seems the start up of the parallel processes is being affected by our Virus Software (Windows). FYI...Windows has another parmeter which is similar to those mentioned in your post. APT_PM_PLAYER_CONNECT_TIMEOUT This ...