Linux: vmstat

vmstat

Provides real-time reports on CPU consumption, CPU dispatcher run queue, RAM page in, scan rate, RAM page outs. Example:
#vmstat 2 5

procs memory swap io system cpu
r b swpd free buff cache si so bi bo in cs us sy id wa
0 0 11160 327148 35036 3446588 0 1 1 0 0 0 0 0 0 1

Procs
r: The number of runnable processes waiting for access to the CPU.
b: The number of processes in uninterruptible sleep.

Memory
swpd: the amount of virtual memory used.
free: the amount of idle memory.
buff: the amount of memory used as buffers.
cache: the amount of memory used as cache.
inact: the amount of inactive memory. (-a option)
active: the amount of active memory. (-a option)

Swap
si: Amount of memory swapped in from disk (/s).
so: Amount of memory swapped to disk (/s).

IO
bi: Blocks received from a block device (blocks/s).
bo: Blocks sent to a block device (blocks/s).

System
in: The number of interrupts per second, including the clock.
cs: The number of context switches per second.

CPU
These are percentages of total CPU time.
us: The percentage of the time the CPU ran user-level code (non-kernel. (user time, including nice time)
sy: Time spent running kernel code. (system time)
id: The percentage of the time the CPU was idle. Prior to Linux 2.5.41, this includes IO-wait time.
wa: Time spent waiting for IO. Prior to Linux 2.5.41, shown as zero.

Ascential DataStage: Routine to Reset Sequnce Key

If you use the KeyMgtGetNextValue routine in your job to assign a sequence value for you key, and you want to set the key to a special value, there is no routine come with DataStage for you to reset the key. You need to create one for your own.

1. Login to your project from DataStage Manager.
2. Select File àNew Server Routine
3. From the SDK editor, select the General tab and do:
4. Give a routine name, for example: SetKeyValue, in the Routine name field.
5. Select Transformer Function from Type list.
6. Select or enter a Category in the Category field.
7. Enter a short and long descriptions as you wish
8. Select the Arguments Tab and enter two arguments
---- SeqKeyName this is the name associated with the sequence.
---- KeyValue. This is the value you want to set for your key.
9. Select the Code Tab and place the following codes in the code window.
Common /Sequences/ Initialized, NewVal, SeqFile
## open the SDKSequence file
Open "SDKSequences" TO SeqFile Else
EXECUTE "CREATE.FILE SDKSequences 2 1 1"
Open "SDKSequences" TO SeqFile
Else Call DSLogFatal('Unable to Open Sequence file','Reset Sequence Job')
End
## Write the new value to the file
NewVal = KeyValue
Writeu NewVal ON SeqFile,SeqKeyName
Else Call DSLogFatal('Unable to write New Value','Reset Sequence Job')
## return the values
Ans = NewVal
10. Select Compile from the bottom of the screen and make sure there is no error.
11. Select Test from the bottom of the screen and test the Routine. It should return the value of KeyValue.
12. To reset the key using the routine you just created, create a new job from the designer. In your job, user a transformer to trigger the routine.

Ascential DataStage: Find Out What a Job Description Number Is for a Particular Job

If you take a look of the project directory, you will see something like RT_OCNFIG56 or RT_LOG56.  Each of the file reresent a job. To find out what is the job description number for a particular job, do the following:

1.Login to DataStage as root.
2.Launch the DataStage TCL prompt
3.At TCL prompt, enter “LOGTO " to log into the project account. The project name is case sensitive.

 To fine out what the job description number, enter "LIST  DS_JOBS " The job name is case sensitive. The output will look like the following:

Job name.... seqLoadAll
Description.
No.......... 746
Category.... PROJECTABC\Sales\Sequence\Main


References:

• DataStage Documentation
• Other References On The Web

Related Posts:

• Ascential DataStage: Cleanup Resources To Release Orphans Processes
• Ascential DataStage: Unlock a User's Processes and Clean Resources