Problem description
we configured datastage to use RAM disk when using the scratch pad
resource, please see config file below:-
node "node1"
{
fastname "cb17biretlprd"
pools ""
resource disk "/opt/dstransfer/Datasets" {pools ""}
resource scratchdisk "/BIR_RAMDISK" {pools ""}
resource scratchdisk "/opt/dstransfer/Scratch" {pools ""}
}
node "node2"
{
fastname "cb17biretlprd"
pools ""
resource disk "/opt/dstransfer/Datasets" {pools ""}
resource scratchdisk "/BIR_RAMDISK" {pools ""}
resource scratchdisk "/opt/dstransfer/Scratch" {pools ""}
}
We encountered the following error message with some of our jobs that
were performing oracle truncate and load tasks. If the RAM disk became
full we expected the scratch disk to overflow into
"/opt/dstransfer/Scratch"
but it seems this did not happen. Please advise?
Job name:NEX_FacilityAgreementRiskRatingLoad
Event #:12875
Timestamp:15/04/2012 00:31:20
Event type:Fatal
User:prdstage
Message:
next_facilityagrriskrating,1: Unable to create FIFO with name
'/BIR_RAMDISK/ora.3280982.627419.fifo.1' and mode 00666 - No space left
on device
Project:prod (biretlprd)
Job name:NEX_FacilityAgreementRiskRatingLoad
Event #:12876
Timestamp:15/04/2012 00:31:20
Event type:Fatal
User:prdstage
Message:
next_facilityagrriskrating,1: The runLocally() of the operator failed.
Project:prod (biretlprd)
Job name:NEX_FacilityAgreementRiskRatingLoad
Event #:12879
Timestamp:15/04/2012 00:31:20
Event type:Fatal
User:prdstage
Message:
next_facilityagrriskrating,0: Unable to create FIFO with name
'/BIR_RAMDISK/ora.3280982.627419.fifo.0' and mode 00666 - No space left
on device
Project:prod (biretlprd)
Job name:NEX_FacilityAgreementRiskRatingLoad
Event #:12880
Timestamp:15/04/2012 00:31:20
Event type:Fatal
User:prdstage
Message:
next_facilityagrriskrating,0: The runLocally() of the operator failed.
Project:prod (biretlprd)
Job name:NEX_FacilityAgreementRiskRatingLoad
Event #:12889
Timestamp:15/04/2012 00:31:20
Event type:Fatal
User:prdstage
Message:
next_facilityagrriskrating,0: Cannot create parm file: ora.
3280982.627419.0.par; error: No space left on device.
Project:prod (biretlprd)
Job name:NEX_FacilityAgreementRiskRatingLoad
Event #:12890
Timestamp:15/04/2012 00:31:20
Event type:Fatal
User:prdstage
Message:
next_facilityagrriskrating,1: Cannot create parm file: ora.
3280982.627419.1.par; error: No space left on device.
Project:prod (biretlprd)
Job name:NEX_FacilityAgreementRiskRatingLoad
Event #:12902
Timestamp:15/04/2012 00:31:26
Event type:Control
User:prdstage
Message:
Job NEX_FacilityAgreementRiskRatingLoad aborted.
Configuration of RAM disk for scratch pad usage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 102
- Joined: Thu Sep 17, 2009 1:23 am
-
- Participant
- Posts: 102
- Joined: Thu Sep 17, 2009 1:23 am