Configuration of RAM disk for scratch pad usage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
PeteM2
Premium Member
Premium Member
Posts: 44
Joined: Thu Dec 15, 2011 9:17 am
Location: uk

Configuration of RAM disk for scratch pad usage

Post by PeteM2 »

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.
thanks
rohitagarwal15
Participant
Posts: 102
Joined: Thu Sep 17, 2009 1:23 am

Re: Configuration of RAM disk for scratch pad usage

Post by rohitagarwal15 »

What is the total size of your RAM disk ?
Rohit
PeteM2
Premium Member
Premium Member
Posts: 44
Joined: Thu Dec 15, 2011 9:17 am
Location: uk

Post by PeteM2 »

16 GB
thanks
rohitagarwal15
Participant
Posts: 102
Joined: Thu Sep 17, 2009 1:23 am

Post by rohitagarwal15 »

with such a low RAM disk space you will face such types of issue. Either get your RAM disk space increased or use some other mount point (SAN mounted) for scratch disk purpose.
Rohit
Post Reply