Skip to main content

JCL - MAXI -VALUES



Question: HOW MUCH SPACE OS ALLOCATES WHEN YOU CREATE A PS OR PDS?
Answer: 56 KB

Question: MIN NO OF DATASET NAMES (PDS) IN ONE DIRECTORY BLOCK?
Answer: FOUR - SIX

Question: THE MAXIMUM NUMBER OF STEPS IN A JOB?
Answer: 255

Question: MAX. NO OF DD STATEMENTS IN A JOB
Answer: 3273

Question: What is the maximum number of instream procedures?
Answer: 15

Question: for how long a job can be executed continuously in a mainframe
Answer: 248 DAYS

Question: How much is memory space involved, when we code BLOCKSIZE,TRK & CYL
Answer: One block constitutes 32KB of formatted memory/ 42KB of Unformatted memory, 6 blocks makes one Track & 15 Tracks makes one cylinder.

Question: What is DSNDB06 ?
Answer: This is the Place where DB2 Catalog resides

Question: What is the use of DSNDB07 ?
Answer: This is the area where sorting takes place in DB2

Question: WHAT IS DATACOM DB?
Answer: IT IS A DATABASE USED WITH VSE.

Question: What are the maximum and minimum sizes of any CONTROL AREA (VSAM datasets) ?
Answer: Minimum Size : 1 trackMaximum size : 1 cylinder

Question: WHAT IS COMM?
Answer: COMM - HALF WORD BINARY

Question: What is a procedure?
Answer: A set of precoded JCL that can be modified through the use of parameters or override cards. Note: Procedures can be catalogued or instream.

Question: Q: HOW MANY TIMES SECONDARY SPACE ALLOCATED?
Answer: A: 122 TIMES

Comments

sanjuu said…
wanted details....thanks

Popular posts from this blog

NULL VALUES and NULL INDICATORS in DB2

In DB2, the columns defined as NULL needs to be handled carefully else it will throw null exception error, in order to over come this error data type can be handled by using null indicator.
NULL is stored using a special one-byte null indicator that is "attached" to every nullable column. If the column is set to NULL, then the indicator field is used to record this. Using NULL will never save space in a DB2 database design - in fact, it will always add an extra byte for every column that can be NULL. The byte is used whether or not the column is actually set to NULL. The indicator variable is transparent to an end userConsider below Table :
Create Table SAMP_TABSN CHAR (10) SNAME CHAR (10) STATUS CHAR (2) NOT NULL BY DEFAULTCITY CHAR (10) NOT NULL
Note :: Unless you specify NOT NULL, the default is to allow for NULLIn above table SN and SNAME columns holds null values by default, in order to handle these null variables we need to have NULL-INDICATORS declares in the Program as

How to Solve SOC7 Abend - with screen shots

Below process helps to find out the statement, caused the SOC7 error.


Check the Sysout of RUNJCL. This shows the error statement and lists offset valueTake the Offset Value 000003C0Got to respective Compilation Job listing, check the sysprint Search for the offset value 0003C0 (delete +00 -- initial 3 letters of Offset value and search for it) check below 2 screen shotsThis Offset value is listed under line no 0045 – which refers to Move statement.
Take this no. 045 and find for it in same sysprint. This points to the exact statement, caused SOC7 This 045 pints to the Move statement 1526, this is the exact line in the programCheck for the above line no. In source program. This points to the statement highlighted below. Check the statement, variable check-4, which is added to check-6. These are having different Picture clause.check-4 is alfhanumaric, holding some junk data, when this data is moved to Chcek-6 variable(of comp-3) creates SOC7 error.This is just an example to explain one ca…

DB2 Utilities and Commands (helpful for DB2 Certification)

• Utilities
– Image Copy
– CDB SuperCopy
– Quiesce
– Load
– CDB SuperLoad
– Check
– BSCTIAUL
– CDB SuperUnload
– Recover
– CDB SuperRestore
– Reorg
– CDB SuperReorg
– Runstats
– Report Recovery
– Repair

• Commands
– Display/Stop/Start Database
– Display/Term Utility


DB2 Logging

• DB2 Logs
– A ‘journal’ of all activity for a subsystem
– Undo/redo records for table updates
– Each event in the log is identified by its RBA(relative byte address)
– RBA denotes a point in time: the greater the RBA, the later in time the event occurred
– Data Sharing - LRSNs along with RBAs

– Some events:
• Full image copy
• Quiesce
• Load


Data Sharing

• Benefits of Data Sharing
– High availability
– Workload balancing
– Sysplex parallelism
– Better use of resources


Backing Up Tables

• Image Copy
– Backup for DB2 table spaces
– Can also copy index spaces
– Can perform full (all data) or incremental (changed data) copies
– Can prevent or allow updates by others during copy
– SAMPLIB: DB2COPY

• CDB SuperCopy
– Faster method of creating stan…