Search found 224 matches

by attu
Tue Jul 22, 2008 10:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aborting because of possible memory corruption!
Replies: 2
Views: 935

Aborting because of possible memory corruption!

Hi, Can someone provide any insights on this issue? ETG_Claim_File1,0: Internal Error: (0):impexp/int.C: 1467: sprintf returned more than 213bytes (actual -1). Aborting because of possible memory corruption! Traceback: msgAssertion__13APT_FatalPathFPCcRC11APT_UStringPCci() at 0xd26f2938 sformatted32...
by attu
Wed Jul 16, 2008 3:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error on Regen - UVCONFIG
Replies: 5
Views: 3937

what parameters were changes in uvconfig?
by attu
Tue Jul 15, 2008 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleting Datasets
Replies: 10
Views: 4039

Hi, when I did orchadmin -help it is saying orchadmin not found Thanks, Somaraju from DSHOME source your dsenv from APT_ORCHHOME/bin export LIBPATH=$LIBPATH:$APT_ORCHHOME/lib export PATH=$PATH:$APT_ORCHHOME/bin APT_ORCHHOME=/px; ( where you have your PXEngine) export APT_CONFIG_FILE=/dsadm/Ascentia...
by attu
Tue Jul 15, 2008 10:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleting Datasets
Replies: 10
Views: 4039

pls set your configuration file and datastage environment and then you have to use orchadmin rm <datasetname>
by attu
Wed Jul 09, 2008 9:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: limit on length of table in db2 ee stage
Replies: 2
Views: 1083

limit on length of table in db2 ee stage

Hi Is there a limit in DataStage on the length of a table name ? we are using db2 ee stage and in exception table we are giving a long name of the table Getting this error: IndID_TL_Table,0: SQL2032N The "UHCDM002_ETL_INDIVIDUAL_ID_CONT_ENR_SUM" parameter is not valid. appreciate your sugg...
by attu
Thu Jul 03, 2008 8:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSR_PROJECT (Action=17) error
Replies: 1
Views: 1398

DSR_PROJECT (Action=17) error

Hi Guys, one of the user is not able to log in to datastage. he is getting Error calling subroutine: DSR_PROJECT (Action=17); check DataStage is set up correctly in project test (Subroutine failed to complete successfully (30107) I am able to login to this project but i belong to dstage group. The u...
by attu
Tue Jul 01, 2008 3:55 pm
Forum: General
Topic: Adding a DSN entry
Replies: 3
Views: 1632

Arvind,

you need oracle setup in dsenv

path of ORACLE_HOME
path of ORAHOME
ORACLE_SID
ORASID

entry of oracle dsn in .odbc.ini
entry of oracle dsn in uvodbc.config (project folder)
by attu
Mon Jun 23, 2008 2:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clean up resources in Director
Replies: 8
Views: 4609

So... the 'Show All' buttons don't show you any processes? :? You have to be logged in as the "Administrator" to work with other people's processes. ... The "Show All" doesn't show any of the processes. Previously it has shown all the processes running and their Process ID. Curr...
by attu
Wed Jun 18, 2008 10:47 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: RTI Output Stage
Replies: 1
Views: 2520

RTI Output Stage

I am looking at a job developed by some user....it basically uses an RTI output stage odbc (extract from sql server) --> RTI output What is the purpose of RTI output. What is buffer and timeout parameters used in the stage? this is the log info : RTI_Output_6,0: Input 0 consumed 1275 records How can...
by attu
Thu Jun 12, 2008 10:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: deleting a job
Replies: 10
Views: 3635

Issue was resolved. earlier the job could not be found in director or designer but it was present in manager. I tried to delete it from Manager and got this error message " cannot open executable job file RT_CONFIG6" From adminsitrator i tried this query SELECT COUNT (@ID) FROM RT_CONFIG6;...
by attu
Thu Jun 12, 2008 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: deleting a job
Replies: 10
Views: 3635

deleting a job

Job was deleted by developer from client interface but

SELECT JOBNO FROM DS_JOBS WHERE NAME ='JOBNAME';

Code: Select all

No...

6

1 records listed
where is the job? do I have to run ds.checker?
pls advise..Thanks
by attu
Tue Jun 03, 2008 2:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to audit for a single job
Replies: 2
Views: 941

never mind, i got my answer.
it should be INSTANCE if you would like to know details for one job.
by attu
Tue Jun 03, 2008 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to audit for a single job
Replies: 2
Views: 941

How to audit for a single job

I am trying to look for a job which was modified recently in DS_Audit table. Since it is a job so I am assigning class value =2, but how would I get details for only one job? I tried using @ID but it gives me syntax error. SELECT * FROM DS_AUDIT WHERE CLASS = '2'; It gives details for all jobs. any ...
by attu
Wed May 14, 2008 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Retrieve Logs
Replies: 3
Views: 1036

chulett wrote:They are gone as import deletes the old job, including the log. ...
Thanks for the reply Chulett.
The only way we could do is export the log before we re-import the job.
by attu
Wed May 14, 2008 1:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Retrieve Logs
Replies: 3
Views: 1036

Retrieve Logs

Hi, Please help me understand this: How to retrieve the previous logs of a job which was re-imported recently. When we re-import a job, it gets a new jobno so what happens to the logs in the RT_LOGxxx folder of the previous jobno associated with that job? Is there a way we can retreive those old log...