Search found 28 matches
- Thu Dec 05, 2019 6:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running out of memory
- Replies: 6
- Views: 6432
Thanks Craig and Ray for your reply! I already have the sort method set in aggregator stage and Hash partition defined on the key columns. just an update on the number of records in to transformer and to aggregator stage (approx. 2M records ) --> Trasformer--> (64 M records) ---> Aggregator This the...
- Wed Dec 04, 2019 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running out of memory
- Replies: 6
- Views: 6432
Running out of memory
Hi, I have a job designed as below. While running this job we are running out of DataStage memory issue. I see that there are many records coming out of transformer stage because of the 40 constraints defined. DataStage is holding up all the data in memory before processing the aggregator stage. Can...
- Tue Aug 15, 2017 1:35 pm
- Forum: General
- Topic: Run-time error '5' Invalid procedure call or argument
- Replies: 5
- Views: 6280
Run-time error '5' Invalid procedure call or argument
Thanks Chulett for your reply !
But, its just not me facing this issue. Other team member are having the same issue as well.
But, its just not me facing this issue. Other team member are having the same issue as well.
- Tue Aug 15, 2017 10:22 am
- Forum: General
- Topic: Run-time error '5' Invalid procedure call or argument
- Replies: 5
- Views: 6280
Run-time error '5' Invalid procedure call or argument
Hi , When I try to view the Datastage Director to see the logs , while the job is running. I get this error message "Run-time error '5' Invalid procedure call or argument " When I click "OK" the director crashes. Why does this happen and please let me know if there is a solution ...
- Tue Feb 21, 2017 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading global temporary table in same SP session
- Replies: 5
- Views: 4177
I am calling the stored procedure in the Before SQL of an ODBC connector stage. The stored procedure has 5 input/output parameters that are defined. While making the call to stored procedure stage in the before SQL of ODBC connector , I am passing in parameter values. Can we read the output values o...
- Sat Feb 18, 2017 6:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading global temporary table in same SP session
- Replies: 5
- Views: 4177
- Fri Feb 17, 2017 9:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading global temporary table in same SP session
- Replies: 5
- Views: 4177
Reading global temporary table in same SP session
Hi, I am using a stored procedure stage in datastage to call a db2 Cobol stored procedure .The db2 stored procedure loads the data of to a global temporary table. As datastage ends the db2 session after the call to stored procedure, we are not able to read the data from the global temporary table. D...
- Sun Feb 05, 2017 9:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 stored proc call from stored proc stage
- Replies: 3
- Views: 3419
DB2 stored proc call from stored proc stage
Can we call a cobol stored procedures from datastage 11.x(Parallel job) stored proc stage?
Thanks!
Thanks!
- Thu Feb 02, 2017 10:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 stored proc call from stored proc stage
- Replies: 3
- Views: 3419
DB2 stored proc call from stored proc stage
When I am trying to run the job which is a stored proc stage trying to call a DB2 stored procedure I am getting the below error
[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009'
Any solution to this issue?
Thanks!
[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009'
Any solution to this issue?
Thanks!
- Tue Oct 09, 2007 11:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Warning --Dropping Components
- Replies: 1
- Views: 2233
Transformer Warning --Dropping Components
Hi,
Transformer_12: When checking operator: Dropping component "logo" because of a prior component with the same name.
I am getting this error for all the column in source table
Desgin of job
ODBC ENTERPRISE Stage(SQL SERVER)------>Transformer------->Oracle Enterprise Stage
Transformer_12: When checking operator: Dropping component "logo" because of a prior component with the same name.
I am getting this error for all the column in source table
Desgin of job
ODBC ENTERPRISE Stage(SQL SERVER)------>Transformer------->Oracle Enterprise Stage
- Thu Aug 09, 2007 5:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp Error
- Replies: 1
- Views: 1669
Timestamp Error
Hi, The Design of Job is as follows: ODBC STAGE(SQL Server)------> Transformer -------> OCI STAGE I am try to read a timestamp column from ODBC stage and write the same OCI stage which is also a timestamp column, but when i try to do this i am getting the following error: Oracle_Enterprise_0: Column...
- Tue Aug 07, 2007 4:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle_Enterprise_1,1: Unable to create FIFO with name
- Replies: 7
- Views: 4642
Oracle_Enterprise_1,1: Unable to create FIFO with name
Hi,
When i am trying to load data to oracle database using Oracle Enterprise Stage i am getting the following error:
Oracle_Enterprise_1,1: Unable to create FIFO with name '/Data/CDH/Scratch/ora.10487.567021.fifo.1' and mode 00666 - Permission denied
When i am trying to load data to oracle database using Oracle Enterprise Stage i am getting the following error:
Oracle_Enterprise_1,1: Unable to create FIFO with name '/Data/CDH/Scratch/ora.10487.567021.fifo.1' and mode 00666 - Permission denied
- Sun Jul 29, 2007 11:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Config Files
- Replies: 1
- Views: 1801
Config Files
Hi,
Can any one explain in detail the use of $APT_CONFIG_FILE and $APT_ORACLE_NO_OPS config file and links for PDF to get more information.
Can any one explain in detail the use of $APT_CONFIG_FILE and $APT_ORACLE_NO_OPS config file and links for PDF to get more information.
- Fri Jul 27, 2007 12:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Attempting to Cleanup after ABORT raised in stage
- Replies: 8
- Views: 6611
I have tried that too but i get the same warning as beofre.I tired to run this job with the sequential file as target for 2.8 million records, and i still get the same warning. When I reduce the number of records by applying a filter in the soucre and it seems to work fine.The problem i am assuming ...
- Thu Jul 26, 2007 11:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Attempting to Cleanup after ABORT raised in stage
- Replies: 8
- Views: 6611