3. This will bring the complete list of SDSF column names.
You can move the columns using "/" and "//".
One column in the SDSF that we can bring to fron position in the MAX-RC (which usual is the last column in SDSF) which shows the completion code or the abend code for the job.
TIP-002
VSAM
If you want to make your VSAM data set read-only, use INHIBIT with ALTER command. E.g. ALTER XXX.XX.DATA INHIBIT ALTER XXX.XX.INDEX INHIBIT
TIP-003
JCL
If there is a situation, where you need to code more that 255 steps in a JOB, then you need to split jcl into two jcls, at the end of the first jcl check the condition code and initiate the second jcl.
TIP-004
DB2
How to select the duplicate rows from a table? SELECT columns FROM table GROUP BY columns HAVING COUNT(*) > 1
TIP-005
CICS
Use CALLs instead of LINKs in CICS EXEC CICS LINK - establishes a new run unit - sets up environment - Does CICS table-search - For all this activities, it executes 1400 machine code instructions CALL - It executes around 12 machine code instructions Just replacing EXEC CICS LINK with CALL statement on a case study, it was found that Internal Transaction Response time improved 23 - 78 % Total CPU Time improved 15 - 23 % Dynamic storage use improved 11 - 30 % * CALL used in the study is STATIC CALL . COBOL refered here is VS COBOL II
TIP-006
VSAM
REUSE & REPLACE parameters:
REUSE:
To specify REUSE parameter in DEFINE AIX command on Base Cluster is very useful
REPLACE:
We should use REPLACE parameter in REPRO command only for new additions in Base Cluster
