Search found 154 matches

by dspxguy
Tue Oct 30, 2007 9:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: improper datatype
Replies: 5
Views: 1955

chulett wrote:That or post the block of code around line 165 for us to see. ...
Guys thanks for your responses...

I will post the Basic Code tomorrow first thing in the morning :D
by dspxguy
Tue Oct 30, 2007 9:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: REINDEX
Replies: 4
Views: 1478

If you do the REINDEX and log into the Director/Designer/Manager to find that you can see no jobs - don't despair, it means that there were users logged in during the REINDEX and you just need to do it again. Well, the REINDEX worked just fine and we are haiving no issues while exporting jobs by ca...
by dspxguy
Tue Oct 30, 2007 11:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: REINDEX
Replies: 4
Views: 1478

Thanks AndrW

Will try to do a reindex today when all users are out.

Thanks
by dspxguy
Tue Oct 30, 2007 11:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: improper datatype
Replies: 5
Views: 1955

improper datatype

I am getting this error

Code: Select all

Program "JOB.261291493.DT.1454834689.TRANS1": Line 165, Improper data type.
there is a sequential file ---transfoermer ---sequential file being used.

I check for the RT_BPnnn file and went to line 165, but couldnt understand what was the error.
by dspxguy
Mon Oct 29, 2007 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: REINDEX
Replies: 4
Views: 1478

REINDEX

I am trying to do an export by category and it is throwing this error. Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project abc (Subroutine failed to complete successfully (30107)) But seems to work fine when doing a whole project export. I did C...
by dspxguy
Thu Oct 25, 2007 12:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Corrupt
Replies: 10
Views: 3887

I don't believe your Project is corrupt and that you have to recreate...Just do a UNLOCK AL and then re-index and I'm sure your fine.... The tar backs up the filesystem which is the Project and all its files and you recover the entire Project.....The dsx backs up the Job designs, objects and so on ...
by dspxguy
Thu Oct 25, 2007 12:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Corrupt
Replies: 10
Views: 3887

If there are any outstanding locks then the re-index does not work. Unlock then re-index. You guys might be right, I did check for the clients attaxched to the project, and there was none, but i did not check for any locks that were already held. anyways, we will delete the whole project and create...
by dspxguy
Thu Oct 25, 2007 12:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Corrupt
Replies: 10
Views: 3887

If there are any outstanding locks then the re-index does not work. Unlock then re-index. You guys might be right, I did check for the clients attaxched to the project, and there was none, but i did not check for any locks that were already held. anyways, we will delete the whole project and create...
by dspxguy
Thu Oct 25, 2007 11:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Corrupt
Replies: 10
Views: 3887

If there are any outstanding locks then the re-index does not work. Unlock then re-index. You guys might be right, I did check for the clients attaxched to the project, and there was none, but i did not check for any locks that were already held. anyways, we will delete the whole project and create...
by dspxguy
Thu Oct 25, 2007 10:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Corrupt
Replies: 10
Views: 3887

chulett wrote:You have to use a real job name, not literally 'JOBNAME' in the select. ...
yea in that case , I used the real job name :D
by dspxguy
Thu Oct 25, 2007 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Corrupt
Replies: 10
Views: 3887

Project Corrupt

Hi we are getting this error message when trying to compile jobs or trying to create a copy. Record xxxxxx in file DS_JOBS does not exist. We did a DS.REINDEX ALL ( made sure no one was logged in to clients) Then did SELECT DS_JOBS WHERE NAME='JOBNAME'; 0 records listed. But when I do SELECT DS_JOBO...
by dspxguy
Fri Oct 19, 2007 9:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compressing dat files
Replies: 1
Views: 727

compressing dat files

which one is more effective when compressing large files

compress or gzip..

can we use bzip2?


thanks
by dspxguy
Wed Oct 17, 2007 6:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: orchadmin check
Replies: 3
Views: 1069

You need to also execute your $DSHOME/.dsenv file in order to set your environment settings for libraries and path. ... I did that . ./dsenv but still getting same error. is it because I have not defined the path for libustdio.sl.22 in the dsenv as this is a new install of Enterprise Edition, previ...
by dspxguy
Wed Oct 17, 2007 5:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: orchadmin check
Replies: 3
Views: 1069

orchadmin check

I am getting this error when trying to run this command $ bin/orchadmin check /usr/lib/dld.sl: Can't find path for shared library: libustdio.sl.22 /usr/lib/dld.sl: No such file or directory Abort(coredump) the path to ochadmin is px/bin just wanted to check this after EE install that parallel extend...
by dspxguy
Mon Oct 15, 2007 10:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fatal error message
Replies: 1
Views: 531

fatal error message

one of the job is failing with this error.

Fatal Error: Bad numLogicalFiles: 0

What does it mean?


Any suggestions appreciated.

Thanks