Something about DataStage, DataStage Administration, Job Designing,Developing, DataStage troubleshooting, DataStage Installation & Configuration, ETL, DataWareHousing, DB2, Teradata, Oracle and Scripting.
Showing posts with label disk. Show all posts
Showing posts with label disk. Show all posts
Friday, February 06, 2015
Order of temporary disk space uses by Sort stage
The Sort stage uses temporary disk space when performing a sort. It looks in the following locations, in the
following order, for this temporary space.
1. Scratch disks in the disk pool sort (you can create these pools in the configuration file).
2. Scratch disks in the default disk pool (scratch disks are included here by default).
Friday, November 08, 2013
Conductor Node in Datastage
Below is the sample APT CONFIG FILE ,see in bold to mention conductor node.
{
node "node0"
{
fastname "server1"
pools "conductor"
resource disk "/datastage/Ascential/DataStage/Datasets/node0" {pools "conductor"}
resource scratchdisk "/datastage/Ascential/DataStage/Scratch/node0" {pools ""}
}
Wednesday, September 11, 2013
What can you delete to free up disk space in IBM InfoSphere Information Server
What can you delete to free up disk space in IBM InfoSphere Information Server when disks are becoming full?
What to do ????
Here are some things you can do to clean up space:
- Clear the &PH& file in the Project directory. There is a
&PH& directory in each DataStage project directory, which
contains information about active stages that is used for diagnostic
purposes. The &PH& directory is added to every time a job is
run, and needs periodic cleaning out.
Wednesday, September 04, 2013
Buffering in DataStage
Buffering is a technique used in the Datastage jobs to ensure a constant and uninterrupted flow of data to and from stages in such a way that there is no potential dead lock or any fork join problems. It is been implemented in Datastage keeping in mind the fact that the data has to keep moving in the process with an optimized use of the memory in the server. As mentioned by IBM the ideal scenario is when the data flows through the stages without being written on the disk. As in the case of buffering in any system, the upstream operators should to wait for the downstream operators to consume their input before starting to create their records. This is the intention in Datastage too.
Subscribe to:
Posts
(
Atom
)