Hi,
We are using DataStage 4.2 on Unix.
We have a simple job that has an OCI, a transformer, and a sequential stage.
The OCI draws data from ORACLE tables and load the sequential file through
the transformer.
The job works fine so far until now when our tables produce more than
20-million records. The job consistently aborted when it processed up to
16-million records. The following is the error message.
DataStage Job 2241 Phantom 9026
Abnormal termination of UniVerse.
Fault type is 10. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.1464026617.DT.1281442260.V0S64 at
addrkgefec: fatal error 0
********** Internal heap ERROR 17113 addr=0x0 *********
******************************************************
HEAP DUMP heap name="" desc=0x0
extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0
parent=0 owner=0 nex=0 xsz=0x0
Hla: 0
**** Recursive heap error: 17113 addr=0x0, ds=0
Any input is much appreciated.
Thanks,
Thanh Vu
Internal heap ERROR 17113
One way of dealing it with the problem is to split the inconing data to go
to multiple files. For example a primary key ending with 0 to a file0 so on
to ending woth 9 to a file called file9. Since we are in Datastage 5.x, we
can run multiple instances of the same job where the job selects rows with
the key ending with a specific value(0,1...) passed as a parameter. This
way, u also get great performance.
In 4.2, we used to make copies of the jobs(painful task as u need to keep
all jobs up to date).
"Vu,Thanh,GLENDA
LE,ISD" To: "datastage-users@oliver.com"
Subject: Internal heap ERROR 17113
01/30/2003 12:19
PM
Please respond
to
datastage-users
Hi,
We are using DataStage 4.2 on Unix.
We have a simple job that has an OCI, a transformer, and a sequential
stage.
The OCI draws data from ORACLE tables and load the sequential file through
the transformer.
The job works fine so far until now when our tables produce more than
20-million records. The job consistently aborted when it processed up to
16-million records. The following is the error message.
DataStage Job 2241 Phantom 9026
Abnormal termination of UniVerse.
Fault type is 10. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.1464026617.DT.1281442260.V0S64 at
addrkgefec: fatal error 0
********** Internal heap ERROR 17113 addr=0x0 *********
******************************************************
HEAP DUMP heap name="" desc=0x0
extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0
parent=0 owner=0 nex=0 xsz=0x0
Hla: 0
**** Recursive heap error: 17113 addr=0x0, ds=0
Any input is much appreciated.
Thanks,
Thanh Vu
===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.
to multiple files. For example a primary key ending with 0 to a file0 so on
to ending woth 9 to a file called file9. Since we are in Datastage 5.x, we
can run multiple instances of the same job where the job selects rows with
the key ending with a specific value(0,1...) passed as a parameter. This
way, u also get great performance.
In 4.2, we used to make copies of the jobs(painful task as u need to keep
all jobs up to date).
"Vu,Thanh,GLENDA
LE,ISD" To: "datastage-users@oliver.com"
Subject: Internal heap ERROR 17113
01/30/2003 12:19
PM
Please respond
to
datastage-users
Hi,
We are using DataStage 4.2 on Unix.
We have a simple job that has an OCI, a transformer, and a sequential
stage.
The OCI draws data from ORACLE tables and load the sequential file through
the transformer.
The job works fine so far until now when our tables produce more than
20-million records. The job consistently aborted when it processed up to
16-million records. The following is the error message.
DataStage Job 2241 Phantom 9026
Abnormal termination of UniVerse.
Fault type is 10. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.1464026617.DT.1281442260.V0S64 at
addrkgefec: fatal error 0
********** Internal heap ERROR 17113 addr=0x0 *********
******************************************************
HEAP DUMP heap name="" desc=0x0
extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0
parent=0 owner=0 nex=0 xsz=0x0
Hla: 0
**** Recursive heap error: 17113 addr=0x0, ds=0
Any input is much appreciated.
Thanks,
Thanh Vu
===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.