IBM MAINFRAMES

DB2-4

2012-06-28T21:45:00.002+05:30

Q. What will the copy utility do?

A The copy utility will create an image copy of a tablespace or a dataset within a tablespace. There are two types of image copies : full and incremental. A full image copy copies all pages in a tablespace or dataset. An incremental image copy copies only pages that has been modified since the last use of the COPY utility.

Q. What will the LOAD utility do?

A The LOAD utility can load data into one or more tables in a tablespace or partition. The LOAD can also replace contents of a single partition or an entire tablespace.

Q. What can the MERGECOPY utility do?

A It can merge several incremental copies of a tablespace to make a single incremental copy and it can merge incremental copies with a full-image copy to make a new full-image copy.

Q. What will the RECOVER utility do?

A This utility recovers data to the current state or a previous state. The largest unit of data recovery is the tablespace; the smallest is a page. Data is recovered from image copies of a tablespace and database log change records.

Q. What will the REORG utility do?

A It will reorganize a tablespace to improve access performance and reorganize indexes so that they are more efficiently clustered.

Q. What will the REPAIR utility do?

A It will repair invalid data with valid data and/or reset status conditions. The data may be your own data or data you would not normally access : space map pages and index entries.

Q. What will the RUNSTATS utility do?

A RUNSTATS will scan tablespaces or indexes gathering information about utilization of space and efficiency of indexes. The information is stored in the DB2 catalog and is used by SQL optimizer to select access paths to data during the bind.

Q. What will the STOSPACE utility do?

A This utility updates DB2 catalog columns that tell how much space is allocated for storage groups and related tablespace and indexes.

Q. While the Copy Pending flag is on, is the tablespace that is just recovered available for use?

A No, it is not available.

Q. How do you debug a DB2 STORED PROCEDURE?

A I want someone to answer it.

Q. Max number of columns in a db2 table?

A 224

Q I need to view the number of tables existing under one particular Owner. Is it

possible? If so, pl give the SQL query for this?

A The query SELECT * FROM SYSIBM.SYSTABLES WHERE CREATOR =

'owner id' This displays the table names with that If you want only the number of

tables give the following query. SELECT COUNT(*) FROM

SYSIBM.SYSTABLES WHERE CREATOR = 'owner id' Make sure that you

are in correct subsystem.

Q I need to view the number of tables existing under one particular Owner. Is it

possible? If so, pl give the SQL query for this?

A The query SELECT * FROM SYSTABLES WHERE OWNER= should work.

Q I need to view the number of tables existing under one particular Owner. Is it

possible? If so, pl give the SQL query for this?

A Answer to Ravi's query: Db2 records information for its operation in a catalog

which is actually a group of tables. So we can use the SYSTABLES to get

answer to ur query.

Q What is JOIN and different types of JOIN?

A The ability to join rows and combaine data from two or more tables is one of the

most powerful features of relational system.Three type of joins:1. Equi-

join2.Non-equijoin3.self-join

Q. Can I alter a table (e.g. adding a column) when other user is selecting some

columns or updating some columns from the same table?

A yes possible. until the updation or selection is commited db2 table will not be

restructured. new column definition will be there but it will not be included until all

the tasks on the table are commited.

Q. How many subqueries can you combine together ?

A Total 16 queries and subqueries are 15

Q . What are the different methods of accessing db2 from tso?B.How is the

connection established between TSO & DB2?

A . There are three ways in establishing tso/db2 connection 1. SPUFI 2. QMF 3.

CATALOG VISIBILITY B. A thread between TSO & DB2 is established while

attempting to make connection between tso & db2.

Q. How many buffer bools are available in db2?

A Ten 32k size bufferpools and fifty 4k size buffer pools (bp0 to bp49)default

buffer pools are bp0,bp1,bp2 & bp32

Q B37 abend during spufi

A The b37 abend in the spufi is because of space requirements , the query has

resulted in so many rows that the spufi.out file is not large enough to handle it,

increase the space allocation of spufi.out file.

Q How many Bufferpools are there in DB2 and what are they?

A There are 4 Bufferpools.They are BP0,BP1,BP2 and BP32.

Q What is the command used by TSO users to invoke DB2?

A DSN RUN

Q what is the error code -803 ?

A unique index violation

Q How do you install DB2?

A Install DB2 according to the procedure fo the manual

Q how do you filter out the rows retrieved from a Db2 table ?

A one way is to use The Sql WHERE clause.

Q what is a collection?

A collection is something that every programmer should assign/Specify for every

package. this about 1-18 characters long.

Q What is Skeleton cursor table (SKCT)?

A The Executable form of a Plan. This is stored in sysibm.sct02 table.

Q what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the

current SQLID register contain?

A Pic s9(x-y)V9(Y) Comp-3; the current SQLID contains the current authorization

ID.

Q Can we declare DB2 HOST variable in COBOL COPY book?

A NO.If we declare DB2 host variable in COBOL COPY book, at the time of Pre-

compilation we get the host variable not defined, because pre-compiler will not

expand COBOL COPY book. So we declare it either in DCLGEN with EXEC

SQL INCLUDE Dclgenname END-EXEC or we directly hardcode it in the

working storage section.

Q What should be specified along with a cursor in order to continue updating

process after commit?

A With Hold option.

Q WHAT IS THE NAME OF THE DEFAULT db2 CATALOG DATABASE?

A DSNDB06

Q When Can you be sure that a query will return only one row?

A When you use the primary key and only the primary key in the where clause.

Q what is the difference between join and union?

A join is used to retrive data from different tables using a single sql statement.union

is used to combine the results of two or more sql querries.

Q What is a corelated subquerry?

A In a subquerry, if the outer querry reffers back to the outcome of innerquerry it is

called corelated subquerry. That's why the outer querry is evaluated first unlike an

ordinary subquerry

Q What are the functions of Bind?

A BIND mainly performs two things syntax checking and authorization checking.It

binds together all packages into an application plan hence the name BIND.Apart

from this bind has optimiser as a subcomponent.Its function is to determine the

optimum access strategy.

Q MAX. NO OF ROWS PER PAGE?

A 127

Q The only place of VSAM KSDS in DB2 is?

A BSDS is a VSAM KSDS.

Q CAN ALL USERS HAVE THE PRIVILAGE TO USE THE SQL

STATEMENT SELECT * (DML)?

A NO THE USER SHOULD BE GRANTED PRIVILAGE TO USE IT.

Q What is the size of a data page?

A 4K to 8K

Q what's the best locksize that you could use when you create a tablespace?

A The answer is Locksize = ANY.Unless you are Sure what's the Purpose of
tablespace ie.,Read-only or R/W.If you use lock size =any, Db2 would
automatically determine what type of locks it should use.

Q what's the error code for Unique Index Voilation?

A 803

Q what's the percentage free space for?

A ZERO

Q Can you define an Index if the table size less than 10 PAGES?

A NO

Q What's the Maximum Length of SQLCA and what's the content of SQLCABC?

A The Max length is 136. and the SQLCABC has the Value of SQLCA.

Q what's the percentage free space for?

A The answer is ZERO.

Q What's the maximum number of volumes that can be added to a STOGROUP?

A The answer is 133.Usually it will be difficult monitor more than 3 or 4 volumes to a
Stogroup.

Q What's the maximum number of characters that a tablename can have?

A The answer is 18 characters.

Q What is the meaning of -805 sql return code?

A Program name not in plan. Bind the plan and include the DBRM for the program
named as part of the plan.

Q when does the sql statement gets executed when you use cursor in the application
programming ?

A sql statement gets executed when we open cursor

Q What does CURRENTDATA option in bind indicate?

A CURRENTDATA option ensures block fetch while selecting rows from a table. In
DB2V4 the default has been changed to NO. Therefore it is necessary to change
all the bind cards with CURRENTDATA(YES) which is default in DB2V3 &
earlier to CURRENTDATA(NO).

Q What is the difference between TYPE 1 index & TYPE 2 index?

A TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2
index is the option which comes with DB2V4. With TYPE 2 index data can be
retreived faster as only the data pages are locked and not the index pages. Hence
TYPE 2 index is recommended.

Q What are the levels of isolation available with DB2V4?

A CS RR UR( added new for DB2V4 which stands for uncommited read which
allows to retreive records from the space which has exclusive locks also but data
integrity will be affected if this option is used )The best available option for data
integrity & data concurrency is CS.

Q How do you achieve record locking in DB2 in the versions which donot support
record level locking?

A Y'day I had posted this que. The answer shud hv read as follows:By having the
record length more than half of the page size

Q How do u achieve record level locking in DB2 versions when record level locking is
not allowed?

A By having the length of the record greater than that of a page!

Q In a DB2-CICS program which is acts as co-ordinator and which is participant?

A DB2 - participant CICS- coordinator

Q What does DML stand for and what are some examples of it?

A Data Manipulation Language. Some examples are SELECT, INSERT, DELETE,
REPLACE.

Q How to define the dataitems to receive the fetch items for the SQL?

A Using the DSECT, followed by lines of - 'dataitems DS datatype'.

Q How will you delete duplicate records from a table?

A Delete From Table1Where Id In (Select Id From Tabel1 As Temp Group By Id
Having Count(*) >1)

Q What is the difference between Where and Having Clause?

A WHERE is for Rows and HAVING is for Groups

Q How to see the structure of db2 table?

A Using QMF.

Q How do you declare a host variable (in COBOL) for an attribute named EMP-
NAME of type VARCHAR(25) ?

A 01 EMP-GRP. 49 E-LEN PIC S9(4) COMP. 49 E-NAME PIC X(25).

Q What is the maximum number of tables that can be stored on a Partitioned Table
Space ?

A ONE

Q Name the different types of Table spaces?

A 1. Simple Table Space2. Segmented Table Space and3. Partitioned Table Space

Q what are the max. & min. no. of partitions allowed in a partition tablespace?

A minimum is 4.maximum is 64.

Q what is the maximum number of tables that can be joined ?

A fifteen

Q What technique is used to retrieve data from more than one table in a single SQL
statement?

A The Join statement combines data from more that two tables

Q What is a foreign key?

A It identifies a releated row in another table and establishes a logical relationship
between rows in two tables.

Q Explain the use of the WHERE clause?

A It directs DB2 to extract data from rows where the value of the column is the same
as the current value of the host variable.

DB2-3

2012-06-11T11:15:00.000+05:30

Q. What is a row?

A A row is a single occurrence of columns (of data) described by the table definition.

Q. Describe what a storage group (STOGROUP) is?

A A STOGROUP is a named collection of DASD volumes to be used by tablespace and index space of databases. The volumes of a STOGROUP must be of the same device type.

Q. What is meant by synonym?

A A synonym is an alternate name for a table or view which is stored in the SYSIBM.SYSSYNONYMS table.

Q. Describe what a table is?

A A table is a DB2 structure in which column names are used to specify the information that is being stored by row.

Q. What is a tablespace?

A A tablespace is a VSAM dataset which is used to store one or more tables. The physical page can consist of 4K or 32K pages.

Q. How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

A 1. If the tablespace used is only allocated to that STOGROUP :

· ALTER STOGROUP-add volume (new) delete volume (old)

· REORG TABLESPACE or RECOVER TABLESPACE

2. Create a new stogroup that points to the new volume. ALTER the tablespace and REORG or RECOVER the tablespace.

Q. What is the format (internal layout) of 'TIMESTAMP'?

A This is a seven-part value that consists of a date (yymmdd) and time (hhmmss and microseconds).

Q. What is a unique index?

A An index specified as unique is an index for which no duplicates are allowed.

Q. What is meant by a unit of recovery?

A This is a sequence of operations within a unit of work (i.e., work done between commit points).

Q. What is a view?

A A view is an alternative representation of data contained in one or more tables. A view can include all or some of the columns contained in the table or tables.

Q. What does a view do?

A A view restricts access to specific columns and rows.

Q. What is a data model?

A A data model is a way of representing entities, attributes and relationships.

Q. When a transaction issues a commit, to what is the commit writing?

A A commit triggers a write to a log record.

Q. Can DASD types assigned to storage groups by intermixed (i.e., 3350s and 3380s)?

A No.

Q. What type of information is contained on the BSDS?

A The BSDS contains information about active and archive logs, their dataset names and volumes on which they reside.

Q. What are the three types of page locks that can be "held"?

A Exclusive, update, and share.

Q. Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

A DB2 can be invoked by TSO users by using the DSN RUN command.

Q. What are the names of the different types of DB2 tablespaces?

A Simple, segmented and partitioned.

Q. What is the maximum number of partitions allowed in a partitioned tablespace?

A The maximum is 64.

Q. How are write I/Os from the buffer pool executed?

A Asynchronously.

Q. After a table has been recovered, which flag is turned on?

A The Copy Pending flag is turned on.

Q. What is the DB2 catalog?

A The DB2 catalog is a set of tables that contain information about all the DB2 objects (tables, views, plans, etc.).

Q. In which column of which DB2 catalog would you find the length of rows for all tables?

A In the RECLENGTH column of SYSIBM.SYSTABLES.

Q. What information is held in SYSIBM.SYSCOPY?

A The SYSIBM.SYSCOPY table contains information about image copies made of the tablespaces.

Q. What information is contained in a SYSCOPY "entry"?

A It includes the name of database, tablespace name, and the image copy type (full, incremental, etc.), as well as the date and time each copy was made.

Q. What information can you find in SYSIBM.SYSLINKS table?

A The SYSIBM.SYSLINKS table contains information about the links between tables created by referential constraints.

Q. Where would you find information about the type of database authority held by a user?

A SYSIBM.SYSDBAUTH.

Q. Where could you look if you had a question about whether a column has been defined as an index?

A This information can be found in SYSIBM.SYSINDEXES.

Q. Once you create a view, where would information about the view be stored?

A When a view is created, system information about the view is stored in SYSIBM.SYSVIEWS.

DB2-2

2012-05-29T11:00:00.000+05:30

Q. What will the EXPLAIN do?

A EXPLAIN obtains information (which indexes are used, whether sorting is necessary, which level of locking is applied) about how SQL statements in the DBRM will be executed, inserting this information into "X".PLAN_TABLE where "X" is the authorization ID of owner of the plan.

Q. What is a foreign key?

A A foreign key is a column (or combination of columns) in a table whose values are required to match those of the primary key in some other table.

Q. What will the FREE command do to a plan?

A It will drop (delete) that existing plan.

Q. What will the GRANT option do?

A It will grant privileges to a list of one or more users. If the GRANT option is used in conjunction with the "PUBLIC" option, then all users are granted privileges. Also, you can grant privileges by objects and types.

Q. What does the term "grant privileges" mean?

A Grant privileges means giving access/authority to DB2 users.

Q. What is a host variable?

A This is a data item that is used in an SQL statement to receive a value or to supply a value. It must be preceded by a colon (:) to tell DB2 that the variable is not a column name.

Q. What is an image copy?

A It is an exact reproduction of all or part of a tablespace. DB2 provides utility programs to make full-image copies (to copy the entire tablespace) or incremental image copies to copy only those pages that have been modified since the last image copy.

Q. What is meant by an index?

A An index is a set of row identifiers (RIDS) or pointers that are logically ordered by the values of a column that has been specified as being an index. Indexes provide faster access to data and can enforce uniqueness on the row in a table.

Q. What is an index key?

A It is a column or set of columns in a table used to determine the order of index entries.

Q. What is meant by an index scan?

A. When an entire index (or a portion thereof) is scanned to locate rows, we call this an index scan. This type of access can be used, for example, to select rows of a table in some order and avoid sort for a query.

Q. What is meant by indicator variable?

A An indicator variable is an integer variable used to show whether its associated host variable has been assigned a null value.

Q. What is a join?

A A join is a relational operation that allows retrieval of data from two or more tables based on matching column values.

Q. What is meant by locking?

A Locking is a process that is used to ensure integrity of data. It also prevents concurrent users from accessing inconsistent data. The data (row) is locked until a commit is executed to release the updated data.

Q. What is a “nonleaf” page?

A This is a page that contains keys and page numbers of other pages in the index. Nonleaf pages never point to actual data.

Q. What is meant by null?

A This is a special value that indicates the absence of data in a column. This value is indicated by a negative value, usually -1.

Q. What is an object?

A An object is anything that is managed by DB2 (that is, databases, tablespaces, tables, views, indexes, or synonyms), but not the data itself.

Q. What will the DB2 optimizer do?

A The optimizer is a DB2 component that processes SQL statements and selects the access paths.

Q. What is a page?

A This is the unit of storage within a tablespace or indexspace that is accessed by DB2.

Q. What is a pagespace?

A Pagespace refers either to an unpartitioned table to an index space, or to a single partition of a partitioned table of index space.

Q. What is a predicate?

A A predicate is an element of a search condition that expresses or implies a comparison operation.

Q. Describe a primary key?

A A primary key is a key that is unique, nonnull and is part of the definition of a table. A table must have a primary key to be defined as parent.

Q. What is a recovery log?

A A recovery log is a collection of records that describes sequence of events that occur in DB2. The information is needed for recovery in the event of a failure during execution.

Q. What is a Resource Control Table (RCT)? Describe its characteristics?

A The RCT is a table that is defined to a DB2/CICS region. It contains control characteristics which are assembled via the DSNCRCT macros. The RCT matches the CICS transaction ID to its associated DB2 authorization ID and plan ID (CICS attachment facility).

Q. Where are plans stored?

A Each plan is defined uniquely in the SYSIBM.SYSPLAN table to correspond to the transactions that are to execute that plan.

Q. Describe referential integrity?

A Referential integrity refers to a feature in DB2 that is used to ensure consistency of data in the database.

Q. What is meant by a repeatable read?

A When an application program executes with repeatable read protection, rows referenced by the program cannot be changed by other programs until the program reaches a commit point.

Openings at Broadridge

2012-05-25T15:25:00.002+05:30

Work Location: Hyderabad

Client: Broadridge Financial Services

Job description:

Experience: 2 - 3 years
Expertise in development and maintenance of Mainframe applications using COBOL, JCL, CICS, VSAM, and DB2
Should have hands-on application development and troubleshooting experience
Should have strong communication and client interfacing skills
Should have good knowledge on SDLC and quality process
Should be willing to work in UK/US shift on rotation basis if required
Education: BE / B.Tech / MCA or equivalent is needed

Contact:-
www.broadridge.com
Anamika
040-44544529

DB2-1

2012-05-18T16:25:00.001+05:30

Q. What is DB2 (IBM Database 2)?
A. DB2 is a subsystem of the MVS operating system. It is a database
Management System (DBMS) for that operating system.

Q. What is an access path?
A. The path that is used to get to data specified in SQL statements.

Q. What is an alias?
A. It is an alternate name that can be used in SQL statements to
refer to a table or view in the same or a remote DB2 subsystem.

Q. Explain what a plan is?
A. A plan is a DB2 object (produced during the bind process) that
associates one or more database request modules with a plan
name.

Q. What is a DB2 bind?
A. A bind is a process that builds "access paths" to DB2 tables. A
bind uses Database Request Modules (DBRMs) from the DB2
precompile step as input and produces an application plan. It also
checks user's authority and validates the SQL statements in
DBRMs.

Q. What information is used as input to the bind process?
A. 1. The database request model produced during the precompile.
2. The SYSIBM.SYSSTMT table of the DB2 catalog.

Q. What is meant by attachment facility?
A. The attachment facility is an interface between DB2 and TSO,
IMS/VS, CICS or batch address spaces. It allows application
programs to access DB2.

Q. What is meant by AUTO COMMIT?
A. AUTO COMMIT is a SPUFI option that commits the effects of
SQL statements automatically if they are successfully executed.

Q. What is a base table?
A. A base table is a "real" table-a table that physically exists, in that
there are physical stored records.

Q. What is the function of Buffer Manager?
A. The Buffer Manager is the DB2 component responsible for
physically transferring data between an external medium and
(virtual) storage (performs the actual I/O operations). It
minimizes the amount of physical I/O actually performed with
sophisticated buffering techniques (i.e., read-ahead buffering and
look-aside buffering).

Q. What is a buffer pool?
A. A buffer pool is main storage that is reserved to satisfy the
buffering requirements for one or more tablespaces or indexes
and is made up of either 4K or 32K pages.

Q. How many buffer pools are there in DB2?
A. There are four buffer pools namely : BPO, BPI, BP2, and BP32.

Q. On the create tablespace, what does the CLOSE parameter
do?
A. CLOSE physically closes the tablespace when no one is working
on the object. DB2 (Release 2.3) will logically close tablespaces.

Q. What is a clustering index?
A. It is a type index that locates table rows Determines how rows
are grouped together in the tablespace.

Q. What will the COMMIT accomplish?
A. COMMIT will allow data changes to be permanent. This then
permits the data to be accessed by other ' units of work. When a
COMMIT occurs, locks are freed so that other applications can
reference the just-committed data.

Q. What is meant by concurrency?
A. Concurrency is what allows more than one DB2 application
process to access the same data at essentially the same time.
Problems may occur, such as lost updates, access to
uncommitted data and unrepeatable reads.

Q. What is cursor stability?
A. It is cursor stability that "tells" DB2 that database values read by
this application are protected only while they are being used.
(Changed values are protected until this application reaches a
commit point.) As soon as a program moves from one row to
another, other programs may read or change the first row.

Q. What is the function of the Data Manager?
A. The Data Manager is a DB2 component that manages the
physical databases). It invokes other system components as
necessary to perform detailed functions such as locking, logging
and physical I/O operations (such as search, retrieval, update,
and index maintenance).

Q. What is a Database Request Module (DBRM)?
A. A DBRM is a DB2 component created by the DB2 precompiler
containing the SQL source statements extracted from the
application program. DBRMs are input to the bind process.

Q. What is a data page?
A. A data page is a unit of retrievable data, either 4K or 32K
(depending on how the table is defined) containing user or catalog
information.

Q. What are data types?
A They are attributes of columns, literal and host variables. The data
types are SMALLINT, INTEGER, FLOAT, DECIMAL, CHAR,
VARCHAR, DATE and TIME.

Q. What is a Declarations Generator (DCLGEN)?
A. DCLGEN is a facility that is used to generate SQL statements
that describe a table or view. These table or view descriptions are
then used to check the validity of other SQL statements at
precompile time. The table or view declare are used by the DB2I
utility DCLGEN to build a host language structure which is
used by the DB2 precompiler to verify that correct column
names and data types have been specified in SQL statement.

Q. What does DSNDB07 database do?
A. DSNDB07 is where DB2 does its sorting. It includes DB2's sort
workarea and external storage.

Q. What is meant by dynamic SQL?
A. Dynamic SQL are SQL statements that are prepared and
executed within a program while the program is executing. The
SQL source is contained in host variables rather than being "hard
coded" into the program. The SQL statement may change from
execution to execution.

Q. What is meant by embedded SQL?
A. They are SQL statements that are embedded within an
application program and are prepared during program preparation
process before the program is executed. After it is prepared, the
statement itself does not change (although values of host
variables specified within the statement might change).

Q. What is meant by entity integrity?
A. Entity integrity is when the primary key is in fact unique and not
null.

JCL-6

2012-05-14T09:48:00.000+05:30

Q) What is a Generation Data Group (GDG)?

A) Generation Data Group is a group of chronologically or functionally related datasets. GDGs are processed periodically, often by adding a new generation, retaining previous generations, and sometimes discarding the oldest generation.

Q) How is a GDG base created?

A) A GDG base is created in the system catalog and keeps track of the generation numbers used for datasets in the group. IDCAMS utility is used to define the GDG base.

Q) What is model dataset label(Model DSCB)?

A) A model dataset label is a pattern for the dataset label created for any dataset named as a part of the GDG group. The system needs an existing dataset to serve as a model to supply the DCB parameters for the generation data group one wishes to create. The model dataset label must be cataloged. The model DSCB name is placed on the DCB parameter on the DD statement that creates the generation data group.

Q) How are GDGs concatenated?

A) Generation Data Groups are concatenated by specifying each dataset name and the generation number for all generations of the generation data group. Otherwise to have all generations of a generation data group, omit the generation number. The DD statement will refer to all generations. The result is the same as if all individual datasets were concatenated. If generations are not on the same volume, this will not work.

Q) How is a new GDG coded?

A) A new GDG is coded as (+1) after the dataset name as follows: DSN=JAN.DATA(+1). This will cause all generations to be pushed down one level at the end of the job.

Q) When should DISP=MOD is used?

A) DISP=MOD is used to either extend an existing sequential dataset or to create a dataset if it does not exist. If the dataset exists, then records are appended to the dataset at the end of the existing dataset. If the dataset does not exist, the system treats MOD as if it were NEW, provided that the volume parameter has not been used. If the volume parameter is used, the system terminates the job and does not create the new dataset. MOD can be used to add to a dataset that extends onto several volumes. Always specify a disposition of CATLG with MOD for cataloged datasets, even if they are already cataloged, so that any additional volume serial numbers will be recorded in the catalog.

Q) How is a dataset passed from one step to another?

A) A dataset is passed from one step to another based on what is coded on the DISP parameter. The dataset can only be passed to subsequent steps if PASS was used on the disposition parameter.

Q) How are datasets concatenated?

A) Datasets are concatenated by writing a normal DD statement for the first dataset and then adding a DD statement without a DDNAME for each dataset to be concatenated in the order they are to be read. The following is an example of three datasets concatenated:

//YEARDAT DD DSN=JAN.DATA,DISP=SHR

// DD DSN=FEB.DATA,DISP=SHR

// DD DSN=MAR.DATA,DISP=SHR

Q) What is the difference between the JOBLIB and the STEPLIB statements?

A) The JOBLIB statement is placed after the JOB statement and is effective for all job steps. It cannot be placed in a

cataloged procedure. The STEPLIB statement is placed after the EXEC statement and is effective for that job step

only. Unlike the JOBLIB statement, the STEPLIB can be placed in a cataloged procedure.

Q) Name some of the JCL statements that are not allowed in procs.?

A) Some of the JCL statements which are not allowed in procedures are:

JOB, Delimiter(/*), or Null statements

2. JOBLIB or JOBCAT DD statements

3. DD * or DATA statements

4. Any JES2 or JES3 control statements

Q) What is primary allocation for a dataset?

A) The space allocated when the dataset is first created.

Q) What is the difference between primary and secondary allocations for a dataset?

A) Secondary allocation is done when more space is required than what has already been allocated.

Q) How many extents are possible for a sequential file ? For a VSAM file ?

A) 16 extents on a volume for a sequential file and 123 for a VSAM file.

Q) What does a disposition of (NEW,CATLG,DELETE) mean?

A) That this is a new dataset and needs to be allocated, to CATLG the dataset if the step is successful and to delete the dataset if the step abends.

Q) What does a disposition of (NEW,CATLG,KEEP) mean?

A) That this is a new dataset and needs to be allocated, to CATLG the dataset if the step is successful and to KEEP but not CATLG the dataset if the step abends. Thus if the step abends, the dataset would not be catalogued and we would need to supply the vol. ser the next time we refer to it.

Q) How do you access a file that had a disposition of KEEP?

A) Need to supply Volume Serial Number VOL=SER=xxxx.

Q) MOD, DELETE; What does a disposition of (,DELETE) mean ?

A) The MOD will cause the dataset to be created (if it does not exist), and then the two DELETEs will cause the dataset to be deleted whether the step abends or not. This disposition is used to clear out a dataset at the beginning of a job.

Q) What is the DD statement for a output file?

A) Unless allocated earlier, will have the following parameters: DISP=(NEW,CATLG,DELETE), UNIT , SPACE & DCB

Q) What do you do if you do not want to keep all the space allocated to a dataset?

A) Specify the parameter RLSE ( release ) in the SPACE e.g. SPACE=(CYL,(50,50),RLSE)

Q) What is DISP= (NEW,PASS,DELETE)?

A) This is a new file and create it, if the step terminates normally, pass it to the subsequent steps and if step abends, delete it. This dataset will not exist beyond the JCL.

Q) How do you create a temporary dataset? Where will you use them?

A) Temporary datasets can be created either by not specifying any DSNAME or by specifying the temporary file indicator as in DSN=&&TEMP. We use them to carry the output of one step to another step in the same job. The dataset will not be retained once the job completes.

Q) How do you restart a PROC from a particular step?

A) In job card, specify RESTART=PROCSTEP.STEPNAME where PROCSTEP = name of the JCL step that invoked the PROC and STEPNAME = name of the PROC step where you want execution to start

Q) How do you skip a particular step in a proc/JOB?

A) Can use either condition codes or use the jcl control statement IF (only in ESA JCL).

Q) A PROC has five steps. Step 3 has a condition code. How can you override/nullify this condition code?

A) Provide the override on the EXEC stmt in the JCL as follows:

//STEP001 EXEC procname, COND.stepname=value

All parameters on an EXEC stmt in the proc such as COND, PARM have to be overridden like this.

Q) How do you override a specific DDNAME/SYSIN in PROC from a JCL?

A) //<STEPNAME.DD> DSN=...

Q) What is NOTCAT 2?

A) This is an MVS message indicating that a duplicate catalog entry exists. E.g., if you already have a dataset with dsn = 'xxxx.yyyy' and u try to create one with disp new, catlg, you would get this error. the program open and write would go through and at the end of the step the system would try to put it in the system catalog. at this point since an entry already exists the catlg would fail and give this message. you can fix the problem by deleting/uncataloging the first data set and going to the volume where the new dataset exists(this info is in the msglog of the job) and cataloging it.

Q) What is 'S0C7' abend?

A) Caused by invalid data in a numeric field.

Q) What is a S0C4 error ?

A) Storage violation error - can be due to various reasons. e.g.: READING a file that is not open, invalid address referenced due to subscript error.

JCL-5

2012-05-08T11:16:00.000+05:30

Q) What are SD37, SB37, SE37 abends?

A) All indicate dataset out of space. SD37 - no secondary allocation was specified. SB37 - end of vol. and no further volumes specified. SE37 - Max. of 16 extents already allocated.

Q) What is S322 abend ?

A) Indicates a time out abend. Your program has taken more CPU time than the default limit for the job class. Could indicate an infinite loop.

Q) Why do you want to specify the REGION parameter in a JCL step?

A) To override the REGION defined at the JOB card level. REGION specifies the max region size. REGION=0K or 0M or omitting REGION means no limit will be applied.

Q) What does the TIME parameter signify ? What does TIME=1440 mean ?

A) TIME parameter can be used to overcome S322 abends for programs that genuinely need more CPU time. TIME=1440 means no CPU time limit is to be applied to this step.

Q) What is COND=EVEN ?

A) Means execute this step even if any of the previous steps, terminated abnormally.

Q) What is COND=ONLY ?

A) Means execute this step only if any of the previous steps, terminated abnormally.

Q) How do you check the syntax of a JCL without running it?

A) TYPERUN=SCAN on the JOB card or use JSCAN.

Q) What does IEBGENER do?

A) Used to copy one QSAM file to another. Source dataset should be described using SYSUT1 ddname. Destination dataset should be described using SYSUT2. IEBGENR can also do some reformatting of data by supplying control cards via SYSIN.

Q) How do you send the output of a COBOL program to a member of a PDS?

A) Code the DSN as PDS (member) with a DISP = SHR. The DISP applies to the PDS and not to a specific member.

Q) I have multiple jobs ( JCLs with several JOB cards ) in a member. What happens if I submit it?

A) Multiple jobs are submitted (as many jobs as the number of JOB cards).

Q) I have a COBOL program that Accepts some input data. How do you code the JCL statement for this?

( How do you code instream data in a JCL? )

A) //SYSIN DD*

input data

Q) Can you code instream data in a PROC ?

A) No.

Q) How do you overcome this limitation ?

A) One way is to code SYSIN DD DUMMY in the PROC, and then override this from the JCL with instream data.

Q) How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?

A) To run a non DB2 program,

//STEP001 EXEC PGM=MYPROG

To run a DB2 program,

//STEP001 EXEC PGM=IKJEFT01

//SYSTSIN DD *

DSN SYSTEM(....)

RUN PROGRAM(MYPROG)

PLAN(.....) LIB(....) PARMS(...)

Q) What is STEPLIB, JOBLIB? What is it used for?

A) Specifies that the private library (or libraries) specified should be searched before the default system libraries in order to locate a program to be executed. STEPLIB applies only to the particular step, JOBLIB to all steps in the job.

Q) What is order of searching of the libraries in a JCL?

A) First any private libraries as specified in the STEPLIB or JOBLIB, then the system libraries such as SYS1.LINKLIB. The system libraries are specified in the link list.

Q) What happens if both JOBLIB and STEPLIB is specified ?

A) JOBLIB is ignored.

Q) When you specify mutiple datasets in a JOBLIB or STEPLIB, what factor determines the order?

A) The library with the largest block size should be the first one.

Q) How to change default PROCLIB?

A) //ABCD JCLLIB ORDER=(ME.MYPROCLIB,SYS1.PROCLIB)

Q) The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The DISP in the JCL is SHR and the program opens the file in EXTEND mode. What happens ?

A) Records will be written to end of file (append) when a WRITE is done in both cases.

Q) What are the valid DSORG values ?

A) PS - QSAM, PO - Partitioned, IS - ISAM

Q) What are the differences between JES2 & JES3 ?

A) JES3 allocates datasets for all the steps before the job is scheduled. In JES2, allocation of datasets required by a step are done only just before the step executes.

Q) What are the causes for S0C1, S0C4, S0C5, S0C7, S0CB abends ?

A) S0C1-May be due to 1.Missing or misspelled DD name 2.Read/Write to unopened dataset 3.Read to dataset opened

output 4.Write to dataset opened input 5.Called subprogram not found

S0C4-may be due to 1.Missing Select statement(during compile) 2.Bad Subscript/index 3.Protection Exception

4.Missing parameters on called subprogram 5.Read/Write to unopened file 6.Move data from/to unopened file

S0C5-May be due to 1.Bad Subscript/index 2.Closing an unopened dataset 3.Bad exit from a perform 4.Access to I/O

area(FD) before read

S0C7-may be due to 1.Numeric operation on non-numeric data 2.Un-initialize working-storage 3.Coding past the

maximum allowed sub script

S0CB-may be due to 1.Division by Zero

Q) What are the kinds of job control statements?

A) The JOB, EXEC and DD statement.

Q) What is the meaning of keyword in JCL? What is its opposite?

A) A keyword in a JCL statement may appear in different places and is recognized by its name, eg. MSGCLASS in the JOB statement. The opposite is positional words, where their meaning is based on their position in the statement, eg. in the DISP keyword the =(NEW,CATLG,DELETE) meanings are based on first, second and third position.

Q) Describe the JOB statement, its meaning, syntax and significant keywords?

A) The JOB statement is the first in a JCL stream. Its format is // jobname, keyword JOB, accounting information in brackets and keywords, MSGCLASS, MSGLEVEL, NOTIFIY, CLASS, etc.

Q) Describe the EXEC statement, its meaning, syntax and keywords?

A) The EXEC statement identifies the program to be executed via a PGM= program name keyword. Its format is //jobname EXEC PGM= program name. The PARM= keyword can be used to pass external values to the executing program.

JCL-4

2012-05-03T10:53:00.000+05:30

Q) Describe the DD statement, its meaning, syntax and keywords?

A) The DD statement links the external dataset name (DSN) to the DDNAME coded within the executing program. It links the file names within the program code to the file names know to the MVS operating system. The syntax is // ddname DD DSN=dataset name. Other keywords after DSN are DISP, DCB, SPACE, etc.

Q) What is a PROC? What is the difference between an instream and a catalogued PROC?

A) PROC stands for procedure. It is 'canned' JCL invoked by a PROC statement. An instream PROC is presented within the JCL; a catalogued PROC is referenced from a proclib partitioned dataset.

Q) What is the difference between a symbolic and an override in executing a PROC?

A) A symbolic is a PROC placeholder; the value for the symbolic is supplied when the PROC is invoked, eg. &symbol=value. An override replaces the PROC's statement with another one; it substitutes for the entire statement.

Q) What is RESTART? How is it invoked?

A) RESTART is a JOB statement keyword. It is used to restart the job at a specified step rather than at the beginning.

Q) What is a GDG? How is it referenced? How is it defined? What is a MODELDSCB?

A) GDG stands for generation data group. It is a dataset with versions that can be referenced absolutely or relatively. It is defined by an IDCAMS define generation datagroup execution.

Q) Explain concatenating datasets?

A) Datasets can be grouped in a DD statement one after another, eg. in a JOBLIB statement where the load module can exist in one of many datasets.

Q) What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?

A) DISP=OLD denotes exclusive control of the dataset; DISP=SHR means there is no exclusivity.

Q) What is MOD and when would you use it?

A) DISP=MOD is used when the dataset can be extended, ie, you can add records at the end of an existing dataset.

Q) What are the keywords associated with DCB? How can you specify DCB information? What is the OS precedence for obtaining that DCB information, ie. where does the system look for it first?

A) The keywords associated with the DCB parameter are LRECL, RECFM, BLKSIZE and DSORG. The DCB information can be supplied in the DD statement. The system looks for DCB information in the program code first.

Q) How do you designate a comment in JCL?

A) The comment statement is //* followed by the comments.

Q) What is the meaning of the EXEC statement keyword, COND? What is its syntax?

A) COND specifies the conditions for executing the subsequent job step. The value after the COND= is compared to the return codes of the preceding steps and if the comparison is true, the step is bypassed. (If this answer confuses you, welcome to the club - memorize it and don't ask questions!)

Q) What is the improvement to COND= in the latest version of MVS?

A) MVS now allows for an IF bracketed by an END IF around any job step to replace the COND= syntax. Again, if the IF statement is true, the step is bypassed.

Q) What is the purpose of the PARM keyword in the EXEC statement?

A) The value after the PARM= specifies control information to be passed to the executing program of the job step.

Q) What is the purpose and meaning of the REGION keyword and what JCL statement is it associated with?

A) REGION specifies the maximum CPU memory allocated for a particular job or job step. If REGION is in the JOB card, it relates to the entire job; if in the EXEC statement, it relates to the job step.

Q) What is the purpose and meaning of the TIME keyword and what JCL statement is it associated with?

A) TIME specifies the maximum CPU time allocated for a particular job or job step. If TIME is in the JOB card, it relates to the entire job; if in the EXEC statement, it relates to the job step.

Q) What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement?

A) Data definition name is the eight character designation after the // of the DD statement. It matches the internal name specified in the steps executing program. In COBOL that's the name specified after the ASSIGN in the SELECT ASSIGN statement. Dataset name is the operating system (MVS) name for the file.

Q) How is the keyword DUMMY used in JCL?

A) For an output file DUMMY specifies that the output is to be discarded. For input it specifies that the file is empty.

Q) What does the keyword DCB mean and what are some of the keywords associated with it?

A) DCB stands for data control block; it is a keyword for the DD statement used to describe datasets. Keywords associated with it are BLKSIZE, DEN, LRECL and RECFM.

Q) What is the difference between BLKSIZE and LRECL?

A) LRECL is the logical record length , where as BLKSIZE is multiples of LRECL

Q) Can you execute a PROC from another PROC?

A) I did not know the answer and my interviewer said NO. Later I tried and executed PROC from a PROC, three levels deep. Manuals do not state any limit on PROC calling PROC, or nesting.

Q) What will happen if you attempt to restart a job in the middle of a JCL // IF .... // ENDIF?

A) Job will fall through to the ENDIF (not executing any steps), then resume execution with the first step AFTER the // ENDIF.

Q) How many positional parameters are there in job statement?

A) There are two position parameters in job statement.

Q) What are three parameters you can specify on Job statement as well as on exec stmt ?

A) Time, Region and Cond parameters

Q) How can you trap abends in the JCL?

A) Use IF ABEND statement in the JCL.

Q) How do you restart a step in JCL?

A) Use RESTART=step name.

jcl-3

2012-04-24T09:00:00.000+05:30

Q) How do you pass parameters to the program as the job is being executed ?

A) By using 'parm' parameter in exec statement. the value mentioned here should be declared in linkage section in the program and process thru procedure division. this technique is very useful when you do not know the parameters at the time of coding the programs.

Q) Why do you use a control card?

A) A control card can be a member of a pds or a sequential dataset and is used for storing the date fields, Definitions of VSAM files....etc. You use control card because you cannot use a instream procedure in a procedure. Generally you will be calling a Proc from your Jcl and you cannot code instream procedure in the Proc and so you will point to the dataset which is called control card.

Q) How do you submit JCL via a Cobol program?

A) In your JCL define as //JOBA JOB 1111, JOB1 //STEP01 EXEC PGM=PROG1 //ddname DD SYSOUT=(*,INTRDR)....and your COBOL(PROG1) should look like this SELECT JCL-FILE ASSIGN TO ddname. Open this file and write the JCL statements into this file. E.g. MOVE '//TESTJOB JOB 1111,VISVEISH' TO JCL-REC.MOVE '//STEP01 EXEC PGM=IEFBR14' TO JCL- REC and close this file. Then TESTJOB will be submitted.

Q) How do you submit a JCL under CICS environment ?

A) Pass all the jcl codes to a COBOL variable(should be declare using OCCURS clause) and the write the line one by one to the spool using CICS commands like SPOOLClose SPOOLOpen SPOOLWrite . For more help reffer CECI of CICS or CICS manual

Q) What is the parameter to be passed in the job card for the unlimited time , irrespective of the job class ?

A) TIME=1440

Q) Definition of COND parameter in JCL

A) COND is a condition parameter, consists of 2 sub parameters, 1^st- return code from the previous step, 2^nd- condition. If COND is true, the step on which COND is coded will be BYPASSED.

Q) What is meant by S0C7 system abend code?

A) S0C7 - Data exception error - you will get it whenever you are trying to move the low values or spaces into the numeric field, or compare the numeric fields with low values, or try to do some arithmetic operations on the low values. To avoid this you have to always initialize the numeric fields otherwise they will contain the low values.

Q) How to pass the temp dataset form one JOB step to another?

A) By specifying the DISP as PASS for the temp dataset

Q) What is a COND parameter in JCL?

A) COND means condition parameter. It is compared with system return code of previous step.//step1 exec pgm=abcd//step2 exec pgm=xyz, cond=(4,lt)step2 will be executed when system return code of step1 is less than 4.

Q) Write a jcl to execute a job by 7 a.m on Jan 20,1986 ?

A) THE code IS : //*MAIN DEADLINE=(0700,B,012086)

Q) How many types of libraries are there in JCL ?

A) Libraries are of three types.1.Sytem Libraries: SUCH AS SYS1.LINKLIB2.Private Libraries: SPECIFIED IN A JOBLIB OR STEPLIB DD STATEMENTS.3.Temporary Libraries: CREATED IN A PREVIOUS STEP OF THE JOB.

Q) What u mean by include statement in JCL ?

A) An include statement identifies a member of a pds or pdse that contains. This set of JCL statements is called an include group. The system replaces the include statement with the statements in the include group.

Q) The maximum number of in-stream procedure you can code in any JCL is ?

A) Fifteen(15).

Q) What you mean by skeleton JCl?

A) Jcl which changes during run time i.e. the values for the jcl such as pgm name , dd name will change .ie same jcl can be used for various job, equivalent to dynamic sql...

Q) How do you submit a JCL under CICS environment ?

A) Edit the JCL in Extra partition TDQ and submit the same using some system command (not sure) under CICS subsystem. This is what i think, please clarify....

Q) What is JCL ?

A) JCL is Job Control Language and is used for Batch processing. The startup procedures of OS and standard products like CICS etc are written in JCL. It is interface between operating system(MVS) & application program. when 2 related programs are combined together on control statements is called job control language

Q) What is the max blocksize for a Tape file?

A) It is 32,760.Based on that we can calculate efficient number of Records in a Block

Q) What are the basic JCL Statements for a Job?

A) JOB : Identifies a job and supplies accounting info

EXEC : Identifies a job step by indicating the name of the program to be executed.

DD : Identifies a data set to be allocated for the job step

Delimiter(/*) : Marks the end of an in-stream dataset

Null(//) : Marks the end of a job

Comments(//*) : Provides Comments

PROC : Marks the beginning of a procedure

PEND : Marks the end of a procedure

OUTPUT : Supplies options for SYSOUT processing.

Q) What does the statements: typrun=scan and typrun=hold do in a JCL statement

A) typrun=scan checks the JCL for errors, typrun=hold holds the job until further notice.

Q) Which is the most widely used batch performance monitor for DB2?

A) DB2PM

Q) What is QSAM error usually when it is occurs?

A) Usually it is occurs at the time of job submission.

Q) What is the purpose of include statement in a JCL?

A) It is used as an alternative for STEPLIB. When we specify the dataset name in include ,it will search in all the datasets specified in the include dataset.

Q) What does S0C4 error mean?

A) This error is faced when we execute the COBOL program. The main reason for this error is that a variable is defined with less characters and we are trying to move data which is larger than the actual storage space.

Q) In which table PLAN is registered in ?

A) RCT

Q) What is GDG?

A) GDG - group of dataset that are logically or chronologically related, referred by name and a relative generation number - an integer which identifies the generation of a dataset and is coded in parentheses after dataset name. Absolute GDG name - GxxxxVyy, where xxxx-absolute gen. number, yy-version number. Can be sequential, direct, partitioned. (VSAM - no). Must always be cataloged. Advantage - all datasets have the same name and system keeps track of adding new and retaining previous generations and deleting oldest successive generation. To create a GDG we create a GDG index in the system catalog with IDCAMS utility and then a model (prototype, DSCB) on the same volume to supply DCB information. Empty - when limit is reached all members are removed from the index, otherwise-only oldest. Scratch-removed members are uncataloged & deleted, otherwise - removed & uncataloged, but remain in the system (not members of GDG any more). GDG number is updated at the end of the job. If number is not specified all generations will be processed from the beginning

Q) what do you mean By spooling? Expand SPOOL?

A) This is managed by JES. This is used for Queuing the Outputs that are intended for Printing and are first stored in SPOOLDASD. This can be managed Using

Q) For how long a job can be executed continuously in a mainframe ?

A) 248 DAYS

JCL-2

2012-04-18T08:56:00.005+05:30

Q) Max. No of DD statements in a job ?

A) 3273

Q) How much space OS allocates when you create a PS or PDS?

A) 56 KB

Q) Min no of member’s (PDS) in one directory block?

A) SIX(6)

Q) The maximum number of steps in a job?

A) 255

Q) How much is memory space involved, when we code BLOCKSIZE,TRK & CYL ?

A) One block constitutes 32KB of formatted memory/ 42KB of Unformatted memory,6 blocks makes one Track & 15 Tracks makes one cylinder.

Q) What is DSNDB06 ?

A) This is the Place where DB2 Catalog resides

Q) What is the use of DSNDB07 ?

A) This is the area where sorting takes place in DB2

Q) What is DATACOM db?

A) It is a database used with VSE.

Q) What is a Dummy Utility and what it does ?

A) IEFBR14 is a Dummy utility and it is used for the sake of EXEC PGM= .... statement in JCL[when used it wouldn't perform any task]. e.g. While Allocating a dataset you don't have to run any utility [this could be done by giving disp=new inDD statement]. But for a PGM name must be given in EXEC statement, it is used.

Q) What 3 guidelines do we have to follow when concatenating DD statements?

A) Datasets must be of the same type (disk or tape), All datasets must have the same logical record length, The dataset with the largest blocksize must be listed first.

Q) On the DD statement, what is the main difference between creating a new sequential flat file and a partitioned dataset?

A) SPACE=(n,m) for a sequential file, SPACE=(n,m,p) for a PDS where n, m, and p are numbers. The p designates how many directory blocks to allocate.

Q) What is the difference between IEBGENER, IEBCOPY and REPRO in IDCAMS utility?

A) IEBGENER -- This is a dataset utility for copying sequential datasets which produces a PDS or a member from a

sequential dataset.

IEBCOPY -- This is a dataset utility for copying one PDS to another or to merge PDSs.

REPRO -- This is for copying sequential datasets. More or less same as the IEBGENER.

Q) How do you submit JCL via a Cobol program?

A) Use a file //dd1 DD sysout=(*,intrdr)write your JCL to this file. Pl some one try this out.

Q) How to execute a set of JCL statements from a COBOL program ?

A) Using EXEC CICS SPOOL WRITE(var-name) END-EXEC command. var-name is a COBOL host structure containing JCL statements.

Q) What is the difference between static call & Dynamic call ?

A) In the case of Static call, the called program is a stand along program, it is an executable program . During run time we can call it in our called program. As about Dynamic call, the called program is not an executable program it can executed thru the called program

Q) What is the difference between catalogue procedure and In-Stream procedure?

A) In Stream procedures are set of JCL statements written between JOB and EXEC statements, start with PROC and end with PEND statement. Mainly used to test cataloged procedures. Cataloged procedure is cataloged on the procedure library and is called by specifying the procedure name on the EXEC statement.

Q) What do you feel makes a good program?

A) A program that follows a top down approach. It is also one that other programmers or users can follow logically and is easy to read and understand.

Q) Can we browse or edit the GDG dataset if it is a tape entry?

A) No, You can’t edit or browse the GDG if it resides on tape.

Q) What are the maximum and minimum sizes of any CONTROL AREA (VSAM datasets) ?

A) Minimum Size : 1 track Maximum size : 1 cylinder

Q) How to get cursor position from system in CICS environment ?

A) Get it from EIBCURPOS !

Q) How many parameters are there to a DISP statement and what are their uses ?

A) There are three(3) parameters. Parameter 1: current data set disposition(new, shr, old, mod) Parameter 2: normal close action for data set (catlg, keep, delete) Parameter 3:abend action for data set (catlg, keep, delete).

Q) What is the error code SOC01 indicate ?

A) Operation exception error For e.g. a dataset open error

Q) What is a procedure?

A) A set of precoded JCL that can be modified through the use of parameters or override cards. Note: Procedures can be catalogued or instream.

Q) What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?

A) OLD specifies exclusive use of a dataset, SHR allows multiple jobs to concurrently access the dataset Note: When updating a dataset, you would normally use OLD.

Q) What are the three basic types of statements in a jobstream?

A) JOB(one per jobstream)EXEC(one or more per job)DD(one or more per jobstep)

Q) What does SYSIN * indicate?

A) Instream data follows this card and is terminated when followed by a card containing // or /* in columns 1 and 2.

Q) What are three major types of JCL statements? What are their functions?

A) JOB - indicates start of jobstream to the operating system and through parms coded on it, certain details about the

job (time, region, message level, job accounting data).

EXEC – indicates the start of execution of a particular job step, be that step a program or a proc.

DD - is a data definition, which is used to describe the attributes of a data set (name, unit, type, space, disposition).

JCL-1

2012-04-13T08:46:00.003+05:30

Q. What are the kinds of job control statements?

A. The JOB, EXEC and DD statement.

Q. What is the meaning of keyword in JCL? What is its opposite?

A. A keyword in a JCL statement may appear in different places and is recognized by its name, eg. MSGCLASS in the JOB statement. The opposite is positional words, where their meaning is based on their position in the statement, eg. in the DISP keyword the =(NEW,CATLG,DELETE) meanings are based on first, second and third position.

Q. Describe the JOB statement, its meaning, syntax and significant keywords?

A. The JOB statement is the first in a JCL stream. Its format is // jobname, keyword JOB, accounting information in brackets and keywords, MSGCLASS, MSGLEVEL, NOTIFIY, CLASS, etc.

Q. Describe the EXEC statement, its meaning, syntax and keywords.

A. The EXEC statement identifies the program to be executed via a PGM=program name keyword. Its format is //jobname EXEC PGM=program name. The PARM= keyword can be used to pass external values to the executing program.

Q. Describe the DD statement, its meaning, syntax and keywords.

A. The DD statement links the external dataset name (DSN) to the DDNAME coded within the executing program. It links the file names within the program code to the file names know to the MVS operating system. The syntax is // ddname DD DSN=dataset name. Other keywords after DSN are DISP, DCB, SPACE, etc.

Q. What is a PROC? What is the difference between an instream and a catalogued PROC?

A. PROC stands for procedure. It is 'canned' JCL invoked by a PROC statement. An instream PROC is presented within the JCL; a catalogued PROC is referenced from a proclib partitioned dataset.

Q. What is the difference between a symbolic and an override in executing a PROC?

A. A symbolic is a PROC placeholder; the value for the symbolic is supplied when the PROC is invoked, eg. &symbol=value. An override replaces the PROC's statement with another one; it substitutes for the entire statement.

Q. What is RESTART? How is it invoked?

A. RESTART is a JOB statement keyword. It is used to restart the job at a specified step rather than at the beginning.

Q. What is a GDG? How is it referenced? How is it defined? What is a MODELDSCB?

A. GDG stands for generation data group. It is a dataset with versions that can be referenced absolutely or relatively. It is defined by an IDCAMS define generation datagroup execution.

Q. Explain concatenating datasets.

A. Datasets can be grouped in a DD statement one after another, eg. in a JOBLIB statement where the load module can exist in one of many datasets.

Q. What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?

A. DISP=OLD denotes exclusive control of the dataset; DISP=SHR means there is no exclusivity.

Q. What is MOD and when would you use it?

A. DISP=MOD is used when the dataset can be extended, ie, you can add records at the end of an existing dataset.

Q. What are the keywords associated with DCB? How can you specify DCB information? What is the OS precedence for obtaining that DCB information, ie. where does the system look for it first?

A. The keywords associated with the DCB parameter are LRECL, RECFM, BLKSIZE and DSORG. The DCB information can be supplied in the DD statement. The sysem looks for DCB information in the program code first.

Q. How do you designate a comment in JCL?

A. The comment statement is //* followed by the comments.

Q. What is the meaning of the EXEC statement keyword, COND? What is its syntax?

A. COND specifies the conditions for executing the subsequent job step. The value after the COND= is compared to the return codes of the preceding steps and if the comparison is true, the step is bypassed. (If this answer confuses you, welcome to the club - memorize it and don't ask questions!)

Q. What is the improvement to COND= in the latest version of MVS?

A. MVS now allows for an IF bracketed by an END IF around any job step to replace the COND= syntax. Again, if the IF statement is true, the step is bypassed.

Q. What is the purpose of the PARM keyword in the EXEC statement?

A. The value after the PARM= specifies control information to be passed to the executing program of the job step.

Q. What is the purpose and meaning of the REGION keyword and what JCL statement is it associated with?

A. REGION specifies the maximum CPU memory allocated for a particular job or job step. If REGION is in the JOB card, it relates to the entire job; if in the EXEC statement, it relates to the job step.

Q. What is the purpose and meaning of the TIME keyword and what JCL statement is it associated with?

A. TIME specifies the maximum CPU time allocated for a particular job or job step. If TIME is in the JOB card, it relates to the entire job; if in the EXEC statement, it relates to the job step.

Q. What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement?

A. Data definition name is the eight character designation after the // of the DD statement. It matches the internal name specified in the steps executing program. In COBOL that's the name specified after the ASSIGN in the SELECT ASSIGN statement. Dataset name is the operating system (MVS) name for the file.

Q. How is the keyword DUMMY used in JCL?

A. For an output file DUMMY specifies that the output is to be discarded. For input it specifies that the file is empty.

Q. What does the keyword DCB mean and what are some of the keywords associated with it?

A. DCB stands for data control block; it is a keyword for the DD statement used to describe datasets. Keywords associated with it are BLKSIZE, DEN, LRECL and RECFM.

Q. What is the difference between BLKSIZE and LRECL?

A. BLKSIZE specifies the number of bytes

PROGRAM FUNCTION KEYS IN FILE-AID

2012-04-06T04:30:00.000+05:30

When you begin using File-AID, |-------------|---- --------|------------ -----|

commonly used commands are assigned | PF1/13 | PF2/14 | PF3/15 |

to the PF keys as shown on the right. | HELP | SPLIT | END |

| | | |

You can change these default assignments |--------------|-------------|-----------------|

in option 0.0.3 or via the KEYS command. | PF4/16 | PF5/17 | PF6/18 |

| RETURN | RFIND | RCHANGE |

| | | |

|---------------|------------|------------------|

| PF7/19 | PF8/20 | PF9/21 |

| UP | DOWN | SWAP |

| | | |

|---------------|-------------|-----------------|

| PF10/22 | PF11/23 | PF12/24 |

| LEFT | RIGHT | RETRIEVE |

| | | |

|----------------|------------|-----------------|

GENERAL INFORMATION PA KEYS IN FILE-AID

2012-04-04T03:29:00.000+05:30

The two program access (PA) keys have special meaning in ISPF and File-AID. They are not equated to ISPF or File-AID commands, and they may not be reassigned.

Normally, you should not use PA1 while operating in File-AID full screen mode. However, there are two exceptions.

If you press PA1 after the keyboard has been unlocked by File-AID, it is treated like PA2 (RESHOW). It does not cause exit from File-AID. However, if you press PA1 a second time without any intervening interaction, it causes the current processing to be terminated and the ISPF PRIMARY OPTION MENU is redisplayed.

If you press PA1 after the keyboard has been manually unlocked (by pressing the RESET key), it usually causes the current processing to be terminated. The ISPF PRIMARY OPTION MENU is redisplayed.

You can use PA2 to reshow the last full screen image displayed by File-AID.

You may need to reshow the screen if you accidentally press the ERASE INPUT or CLEAR key, or if you have typed data on the screen that you want ignored and have not yet pressed ENTER or a PF key.

MISCELLANEOUS COMMANDS IN FILE-AID

2012-04-02T02:28:00.000+05:30

Miscellaneous commands cover a variety of functions. They are listed and briefly described below.

KEY Causes a specified key to be retrieved or the key specification screen to be displayed (applies to BDAM, ISAM, VSAM-KSDS, VSAM-RRDS, and IAM files only)

HEX * Causes data to be displayed in either hexadecimal or character format

CAPS * Causes alphabetic data entered from the terminal to be either translated to upper case or left as-is

RESET * Causes a general resetting of intensified messages and incomplete line commands

CHAR Causes a switch from Formatted or Vertical editing modes to Character editing mode

FORMAT Causes a switch from Vertical or Character editing modes to Formatted editing mode (Aliases: FMT, MAP)

VFMT Causes a switch from Formatted or Character editing modes to Vertical editing mode

SPLIT * Causes split screen mode to be entered or changes the location of the split line

SWAP * Moves the cursor to wherever it was previously positioned on the other logical screen of a split screen pair

TSO * Allows a TSO command or CLIST to be entered from any screen

KEYS * Causes an immediate display of a screen on which current PF key definitions are displayed and modifiable

PANELID * Causes all subsequent screens to be displayed/not displayed with the panel identifier shown in the upper left corner of the screen

HELP * Displays additional information about an error or switches to the on-line tutorial

CURSOR * Moves the cursor to the first input field on line 2

PRINT * Causes a snapshot of the current screen to be recorded in the ISPF list file for subsequent printing

PRINT-HI* Same as PRINT except that high-intensity characters on the screen are printed with overstrikes to simulate the high-intensity display

JCL Causes the generated JCL to be displayed

SESSION CONTROL COMMANDS IN FILE-AID

2012-03-31T01:26:00.000+05:30

Session control commands have to do with terminating the current function or switching from one function to another.

The session control commands are:

CANCEL * Causes editing to be terminated without saving the data

END * Terminates the current operation and returns to the next higher level screen (also used to indicate end of table input)

RETURN * Causes an immediate return to the primary option menu or to a specified option

Recursive commands: File-AID has special commands like F1 (Browse), F2 (Edit), F33 (Copy) that let you suspend your current display and start another function. Upon end from the new function, the suspended display is resumed.

The following will be presented only if selected by number:

1 - Recursive Commands

RECORD MANIPULATION COMMANDS IN FILE-AID

2012-03-29T05:25:00.000+05:30

Record manipulation commands allow you to update file contents and to find and change occurrences of a string in a file.

The record manipulation commands are:

INSERT Causes "n" records to be inserted after the current record (not supported for BDAM files)

DELETE Causes "n" records to be deleted beginning with current record (not supported for BDAM files)

REPEAT Causes a record to be repeated "n" times (not supported for BDAM files)

FIND Causes one or all occurrences of a string to be found

RFIND * In Edit or Browse, causes the previous FIND command to be repeated

CHANGE Causes one or all occurrences of a string to be changed

RCHANGE * In Edit, causes the previous CHANGE command to be repeated

SAVE * Causes the data to be stored back into the edit dataset

UNDO Causes the last applied change to data to be reversed

When using an XREF to work with "segmented" records the following are valid:

ADD Insert a segment at a point in the record.

NEXT Display NEXT segment of record using correct layout

REMOVE Remove a segment at a point in the record.

TOP Return to start of record and display base

USE Display layouts and allow manual selection and relocation

GENERAL INFORMATION COMMANDS IN FILE-AID

2012-03-27T03:23:00.001+05:30

File-AID primary commands are divided into four categories listed below. Commands designated with an asterisk (*) have the same syntax and function as in ISPF.

In many File-AID functions, the information to be displayed exceeds the screen size. Scroll commands allow you to move the screen "window" in as many as three dimensions across the information: up/down, left/right, and forward/back. For a more detailed description of scrolling, see the SCROLLING section within GENERAL INFORMATION.

The scroll commands are:

UP * Causes scrolling toward the top of a record, file, record layout, or member list.

DOWN * Causes scrolling toward the end of a record, file, record layout, or member list.

LEFT * Causes scrolling toward the left margin of the data or causes backward scrolling towards the beginning of a file.

RIGHT * Causes scrolling toward the right margin of the data or causes forward scrolling towards the end of a file.

FORWARD Causes record scrolling toward the bottom of the file.

BACK Causes scrolling toward the top of the file.

LOCATE Causes up or down scrolling to the specified line number, label, or member name.

LOCATE Causes up or down scrolling to the record with a label (dataname) or exclude classification. Also causes scrolling to a data-name that contains, in part or full, the data name(occ) string.

LR Causes forward or backward scrolling to a specified record number, label, or any record with a label classification.

GENERAL INFORMATION COMMAND ENTRY in FILE-AID

2012-03-25T04:20:00.000+05:30

File-AID provides commands for commonly used functions. You may enter commands in one of two ways:

1) By typing the command in the command/option field (line 2 of the screen) and then pressing the ENTER key, or

2) By pressing a program function (PF) key to which you have assigned the desired command.

You can assign commands to PF keys using option 0.0.3 or the KEYS command. When you press the PF key, the processing is the same as if you typed the command in the command field and pressed ENTER.

Before you press a PF key, you can enter information in the command field. The PF key definition is concatenated ahead of the contents of the command field. For example, suppose you assign the DOWN command to the PF8 key. If you type "6" in the command field and press PF8, the results are the same as if you had typed "DOWN 6" in the command field and pressed ENTER.

You can stack multiple commands for execution in one interaction by entering a special delimiter between the commands. The default delimiter is a semicolon (;). You can change the delimiter using option 0.0.1. For example:

COMMAND ===> DOWN 10;LEFT

In this example the DOWN and LEFT commands have been stacked.

GENERAL INFORMATION MEMBER SELECTION SCREENS in FILE-AID

2012-03-23T05:17:00.000+05:30

A member selection screen is an alphabetic list of the members of a partitioned dataset. It is displayed when requested from any of the File-AID functions 1-10.

In most functions it is possible to obtain multiple member lists prior to entering the function.

|************************************************

The example at the right | File-AID ---- EDIT - PROJECT.TEST.DATA --------

shows the selection of | COMMAND ===>

member TESTFIL3 from the | NAME VER.MOD CREATED LAST M

partitioned dataset | TEST1 01.04 08/17/93 09/23/

PROJECT.TEST.DATA | TEST2 01.02 06/12/93 09/13/

| S TESTFIL3 01.13 07/29/93 09/20/

| TESTFIL4 01.07 08/01/93 08/29/

| TESTFIL5 01.11 07/01/93 09/01/

Scrollable data display screens show file contents or record layouts and allow up/down scrolling, and in some cases left/right scrolling. On many scrollable data display screens, you can also update file contents by typing over fields on the screen.

The example below shows the edit formatted screen. You can scroll using the UP and DOWN commands, and can update file contents by typing over the FIELD VALUE column.

File-AID ---- EDIT - PROJECT.TEST.DATA(TESTFL3) -------------------- LINE 00001

COMMAND ===> SCROLL ===> PAGE

RCD SEQ NO 1

--------LEVEL NUMBER/DATA-NAME--------- -OFFSET- ---------FIELD VALUE----------

01 ORDER-LINE

05 ITEM-NO 1 PS/2 MOD50

05 QTY-ORDERED 11 100

05 LIST-PRICE 14 2400.00

GENERAL INFORMATION UNSCROLLABLE DATA DISPLAY SCREENS

Unscrollable data display screens show "nonrepeating" information which fits on a single screen. The Selection Criteria Options screen shown below is an example of this type of screen.

********************************************************************************

File-AID ---- Selection Criteria - Options ------------------------------------

COMMAND ===>

Selection criteria options

First, start at the following record KEY

Starting record key ===>

- OR - OR at the following RBA

Starting RBA ===> (both blank for start of file

Initial records to skip ===> 0 then skip this many records

GENERAL INFORMATION INVOKING FILE-AID

2012-03-20T03:12:00.001+05:30

File-AID executes as a dialog under IBM's ISPF dialog manager facility. You can invoke it by selecting the File-AID option from a customized version of the ISPF primary option menu, or from a sub-menu panel your installation has set up.

If the File-AID execution CLISTS have been installed, you may invoke File-AID from any ISPF screen. For example, the command TSO FASTART suspends your current screen and displays the File-AID primary option menu. Upon exit from File-AID your suspended screen is restored.

The following will be presented only if selected by number:

1 - File-AID execution CLISTS

GENERAL INFORMATION SUMMARY OF OPTIONS 0-C

The File-AID primary options are:

OPTION 0 - SPECIFY ISPF AND File-AID PARAMETERS

This option consists of the ISPF-provided parameter option screens and several screens to specify File-AID default parameters.

OPTION 1 - BROWSE FILE

This option is used to display but not change the contents of files using any of three display modes - formatted, vertical, and character.

OPTION 2 - EDIT FILE

This option is used to create, display and change the contents of files using the formatted, vertical, and character display modes.

OPTION 3 - UTILITIES/E

This option accesses a menu of dataset management utilities. Included are:

3.1 Library (PDS directory management and CSECT info),

3.2 Dataset (Non-VSAM dataset allocation, information),

3.3 Copy (Selective record copying for all file types including PDS members),

3.4 Catalog (search catalog using pattern characters)

3.5 VSAM (Define VSAM clusters, indexes, and paths online or in batch),

3.6 Search/Update (Scan or perform global changes for any dataset),

3.7 VTOC (Search volumes for datasets using pattern characters, analyze space),

3.8 Interactive (run File-AID/Batch online),

3.9 Submit (create batch JCL).

OPTION 5 - PRINT FILE

This option is used to print data file contents, the selection criteria and rcd/layout XREFs created in options 6 and 7 of File-AID, formatted record layouts, and audit trail datasets created while editing a data file in option 2 (Edit) or 3.6 (Update) of File-AID.

OPTION 6 - EDIT SELECTION CRITERIA

This option is used to create and maintain selection criteria for use in the Browse, Edit, Copy, Print, and Compare functions.

OPTION 7 - EDIT RCD/LAYOUT XREF

This option is used to create and maintain rcd/layout XREFs for use in other File-AID functions.

OPTION 8 - VIEW RECORD LAYOUT

This option is used to display the contents of COBOL or PL/I layouts as interpreted by File-AID.

OPTION 9 - REFORMAT FILE

This option allows the records of an input file to be reformatted and written to an output file based on record layouts defining the input and output files.

OPTION 10 - COMPARE

This option is used to compare two files and report the differences between them.

OPTION C - File-AID CHANGES

This option documents changes made in the various releases of File-AID.

GENERAL INFORMATION SCREEN FORMATS

File-AID uses the full screen for display and entry of data.

The first three lines of each display, called the heading lines, have a common format for all File-AID displays. The remainder of the screen may contain a list of options, input fields and prompts, or scrollable data.

The first three lines of each display are formatted as follows:

|----------------------------------------|-------------------------------|

line 1: | TITLE | SHORT MESSAGE |

|--------------------------------------- |------|---------- --------------|

line 2: | COMMAND/OPTION | SCROLL |

|---------------------------------------------- --|----------------------|

line 3: | LONG MESSAGE |

|-----------------------------------------------------------------------|

The TITLE area (line 1) identifies the function being performed and, where appropriate, library or dataset information.

The SHORT MESSAGE area (line 1) is used to indicate:

- Current line or column positions

- Successful completion of a processing function

- Error conditions (accompanied by audible alarm)

The COMMAND/OPTION area (line 2) is used to enter a command. On an option selection menu, it may be used to enter either a command or an option.

The SCROLL area (line 2) contains the current scroll amount whenever scrolling is applicable. You may change it by overtyping.

The LONG MESSAGE area (line 3) is used to display an explanation of error conditions upon request (see HELP command). This line will normally be blank or will contain heading (non data entry) information. Dataset specification screens allow you to enter information such as dataset names, member names, and other parameters. The fields in which you may enter information are labeled and preceded with an arrow. If you fail to enter a required value or if you enter inconsistent values, you are prompted with a message.

The example at the right File-AID ------------- Edit - Dataset Specifi

shows the edit dataset COMMAND ===>

specification screen.

Edit Mode ===> C (F=Format

Specify Edit Information:

Edit Dataset name ===> FASAMP.*

Member name ===> (Blank or

Volume serial ===> (If datas

Disposition ===> OLD (SHR or O

Create audit trail ===> N (Y = Yes;

Several fields on dataset specification screens are pre-entered with values that you entered the last time on that screen or on a similar screen. If the values are correct, simply press ENTER. If the values are not correct, overtype the fields that need to be changed before pressing ENTER.

The pre-entered information comes from your user profile, which File-AID automatically builds and maintains across sessions. Information that is maintained in your user profile includes:

- Dataset names and member names

- Job statement information

- SYSOUT class for printed output

- Parameters entered via Option 0 (Parameters)

- PF-Key defaults

FILE_AID KEY FEATURES

2012-03-18T04:10:00.000+05:30

o Eliminates ISPF editing restrictions

- provides on-line editing of sequential, BDAM, PDS, ISAM, IAM, and VSAM files using

formatted, full-screen displays

- eliminates record length restriction

eliminates file size restriction by using selection criteria to limit the number of records to be edited

- supports files in compressed/encrypted format (with I/O exits)

- provides optional audit trail of all records updated, inserted, and deleted while editing a data file

o Uses existing COBOL or PL/I record layouts directly

- the record layout is the sole definition of files thus eliminating the need to redefine the file/data in another language

- superimposing the record layout over raw data brings meaning to that data

- files may be printed in a formatted manner using the record layout

o Has powerful, easy to use, copying and reformatting capabilities

- these capabilities exist in both batch and on-line modes

- no language to learn and no programming required

- records may be selected for copying using selection criteria based on record counts and/or specific values in individual fields .

- selection criteria can be used in the Browse, Edit, Copy, Print, or Compare functions .

o Runs as a single dialog under ISPF

- uses menu-driven, full-screen, interactive ISPF-like displays

- has user defined PF (program function) key support

- can operate "split-screen" with ISPF/PDF

- easy to learn and use

- a fully interactive product with batch capabilities

- executes in storage available above the 16 megabyte line on systems running MVS/XA or MVS/ESA

COPY cmd in FILE-AID

2012-03-10T03:16:00.000+05:30

Copy dataset - one to one Code:

//STEPCOPY EXEC PGM=FILEAID

//DD01 DD DSN=G1SG00AT.INPUT1,DISP=SHR

//DD01O DD DSN=G1SG00AT.OUTPUT1,DISP=OLD

//DD02 DD DSN=G1SG00AT.INPUT2,DISP=SHR

//DD02O DD DSN=G1SG00AT.OUTPUT2,DISP=OLD

//SYSOUT DD SYSOUT=*

//SYSPRINT DD SYSOUT=*

//SYSLIST DD SYSOUT=*

//SYSTOTAL DD SYSOUT=*

//SYSIN DD DUMMY or code COPY as instream

Here by default SYSIN parameter is 'COPY'. Copy is done from DD01 to DD01O although DD02 and DD02O are coded.

Copy dataset - many to many Code:

//STEPCOPY EXEC PGM=FILEAID

//DD01 DD DSN=G1SG00AT.INPUT1,DISP=SHR

//DD01O DD DSN=G1SG00AT.OUTPUT1,DISP=OLD

//DD02 DD DSN=G1SG00AT.INPUT2,DISP=SHR

//DD02O DD DSN=G1SG00AT.OUTPUT2,DISP=OLD

//SYSOUT DD SYSOUT=*

//SYSPRINT DD SYSOUT=*

//SYSLIST DD SYSOUT=*

//SYSTOTAL DD SYSOUT=*

//SYSIN DD *

$$DD01 COPY

$$DD02 COPY

Here DD01 is copied to DD01O and DD02 is copied to DD02O

VSAM FILE CREATION in FILE-AID

2012-03-05T04:53:00.001+05:30

 Type 3, on Mainmenu of FILE-AID

 The following screen will be displayed

  FILE-AID ------------------  EXTENDED UTILITIES  ------------------------------

 OPTION ===>

  1  LIBRARY       - DISPLAY AND MODIFY DIRECTORY ENTRIES; DISPLAY LOAD

                     MODULE CSECT MAPS; BROWSE, DELETE, RENAME PDS MEMBERS

  2  DATASET       - DISPLAY DATASET INFORMATION; ALLOCATE NON-VSAM DATASETS

                     AND GDGS; CATALOG, UNCATALOG, DELETE, OR RENAME DATASETS

  3  COPY          - COPY ENTIRE DATASETS; COPY SELECTED RECORDS; COPY PDS

                     MEMBERS BASED ON NAME, STATISTICS AND/OR CONTENT

  4  CATALOG       - DISPLAY GENERIC CATALOG ENTRIES OR VSAM DATASETS ON A

                     VOLUME IN LIST FORM AND DO DATASET LIST PROCESSING

  5  VSAM          - ALLOCATE, DISPLAY, DELETE, MODIFY, OR RENAME VSAM CLUSTERS,

                     ALTERNATE INDEXES, OR PATHS; MANAGE IAM FILES

  6  SEARCH/UPDATE - FIND AND CHANGE ACROSS PDS MEMBERS.  SEARCH FOR AND/OR

                     UPDATE DATA GLOBALLY IN ANY TYPE OF DATASET.

  7  VTOC          - DISPLAY AND PROCESS DATASETS ON A VOLUME(S)

  8  INTERACTIVE   - EXECUTE FILE-AID/BATCH

 Use option 5 to ALLOCATE, DISPLAY, DELETE, MODIFY OR RENAME VSAM CLUSTERS

 type 5

 Followig screen will be displayed,


     FILE-AID ---------------------  VSAM UTILITY  ---------------------------------
 OPTION ===> A                                                                  
                                                                                
    A     - ALLOCATE CLUSTER                   D  - DELETE                      
    S     - ALLOCATE DATASPACE                 DR - DELETE/DEFINE               
    X     - ALLOCATE ALTERNATE INDEX           T  - DELETE DATASPACE            
    B     - BUILD ALTERNATE INDEX              P  - ALLOCATE PATH               
    BLANK - DISPLAY DATASET INFORMATION        R  - RENAME COMPONENT            
                                               M  - MODIFY COMPONENT            
 SPECIFY DATASET INFORMATION:                                                   
    DATASET NAME           ===> 'SSEE.SETW47.XXXX.XXX.XXXXREAD'
    VOLUME SERIAL          ===>          (REQUIRED FOR OPTIONS S & T)           
                                                                                
 PROCESS ONLINE OR BATCH   ===> O       (O = ONLINE; B = BATCH)                
                                                                                
 SPECIFY MODEL DATASET INFORMATION:                                             
    DATASET NAME           ===>                                                
                                                                                
 SPECIFY CATALOG TO USE IF OTHER THAN DEFAULT SYSTEM CATALOG:                   
    CATALOG NAME           ===>                                                
    CATALOG PASSWORD       ===>          (IF CATALOG IS PASSWORD PROTECTED)     
 ----------------------------------------------------------------------------

 Using above screen, We can ALLOCATE, DELETE, MODIFY VSAM DATA SETS

 If you have any questions on FILE AID. You can post them on FILE AID forum.

 Please send improvement suggestions on this document to srcsinc@yahoo.com

Browsing Mode in File-Aid

2012-03-03T06:49:00.001+05:30

 For browsing datasets use Option 1
 For editing datasets use option 2  
 for both options same screens will be displayed. But In option 2
 you can be able to update dataset. Let us go with option 2 
 type 2
 Following screen will be displayed


     FILE-AID --------------  BROWSE - DATASET SPECIFICATION  ----------------------
 COMMAND ===>                                                                  
                                                                                
 BROWSE MODE                ===> F          (F=FMT; C=CHAR; V=VFMT; U=UNFMT)    
                                                                                
 SPECIFY BROWSE INFORMATION:                                                    
   DATASET NAME OR HFS PATH ===> 'AYS.VXXXXSW47.XXX.XXX.XXXXREAD'                    <-- (1)
   MEMBER NAME              ===>            (BLANK OR PATTERN FOR MEMBER LIST)  
   VOLUME SERIAL            ===>            (IF DATASET IS NOT CATALOGED)       
                                                                                
                                                                                
 SPECIFY RECORD LAYOUT AND XREF INFORMATION:                                    
   RECORD LAYOUT USAGE      ===> S          (S = SINGLE; X = XREF; N = NONE)     <-- (2)
   RECORD LAYOUT DATASET    ===> 'AYS2.DDDD6.XXXX.XXX.XXXX.TPP'                  <-- (3)
   MEMBER NAME              ===> SPPCAA3    (BLANK OR PATTERN FOR MEMBER LIST)   <-- (4)  
   XREF DATASET NAME        ===>                                               
   MEMBER NAME              ===>            (BLANK OR PATTERN FOR MEMBER LIST)  
                                                                                
 SPECIFY SELECTION CRITERIA INFORMATION:     (E = EXISTING; T = TEMPORARY;      
   SELECTION CRITERIA USAGE ===> N           M = MODIFY; Q = QUICK; N = NONE)    <-- (5)  
   SELECTION DATASET NAME   ===>                                               
   MEMBER NAME              ===>            (BLANK OR PATTERN FOR MEMBER LIST)  
    

 
(1) 'AYS.VXXXXSW47.XXX.XXX.XXXXREAD' is the data set which conatains data
 
(2) RECORD LAYOUT USAGE      ===> S   , if you type S here you should provide copy book
    corresponding to above dataset (structure of dataset), type N , if you does not have
    copy book for that data set
 
(3) RECORD LAYOUT DATASET    ===> 'AYS2.DDDD6.XXXX.XXX.XXXX.TPP'   
    This pds contains the copy book
 
(4) MEMBER NAME              ===> SPPCAA3    
    This is the copy book name in the above dataset (step 3). 
 
(5) SELECTION CRITERIA USAGE ===> N 
    This option is used to apply different types of criterias on data
    if you want to see whole data type 'N'
 
 
 
 ENTER 
  
 Following screen will be displayed which contains data 
 This screen shows data record by record, If you want to go to next
 record press F11 , for previous record F10


     File-AID - Browse - AYS.VXXXXSW47.XXX.XXX.XXXXREAD -------------------- COL 1  70
 COMMAND ===>                                                  SCROLL ===> PAGE
                                    LCR4040L-DATA                LENGTH:   32000
 ---- FIELD LEVEL/NAME ------- -FORMAT- ----+----1----+----2----+----3----+----4
 3 GTR4040L-DATA               639/GRP                                          
   5 SDRYR-FILLER1              8/AN   00000001                                
   5 SDRYR-XXXX-NAME            8/AN   LXXE95                                  
   5 SDRYR-FUNCTION-CODE        5/AN   CXXPL                                   
   5 SDRYR-SUB-FUNCTION-CODE    5/AN                                           
   5 SDRYR-XXXXX-XXXX-CODE       3/GRP                                          
     10 SDRYR-XXXX-CDE          2/AN   00                                      
     10 SDRYR-XXXX-CODE         1/AN   0                                       
   5 SDRYR-OFF-NUM              6/GRP                                          
     10 SDRYR-STATE-CODE        2/AN   42                                      
     10 SDRYR-BRANCH-NUM        4/AN   4104                                    
   5 SDRYR-EMPE-INITS           3/AN                                           
   5 SDRYR-EMPE-XXXX-LOCATION   6/AN                                              
   5 SDRYR-XXXX-XX-NUM-1       10/AN                                           
   5 SDRYR-XXX-XXX-NUM          1/AN                                           
   5 SDRYR-APP-XXX-NUM          2/AN                                           
   5 SDRYR-XXX-TYPE             4/AN   SC                                      
   5 SDRYR-XXX-XXXXXX-CODE      1/AN   0   
                                    
 ENTER CHAR (CHARACTER MODE), VFMT (VERTICAL FORMAT), UNFMT (UNFORMATTED)       
    

 type VFMT on command line
 Following screen will be displayed,  (records displayed verically)



      File-AID - Browse - AYS.VXXXXSW47.XXX.XXX.XXXXREAD -------------------- COL 1  26
 COMMAND ===>                                                  SCROLL ===> PAGE
SDRYR-FILLER1 SDRYR-XXXX-NAME SDRYR-XXXXXXON-CODE SDRYR-XXX-XXXXXXX-CODE   
8/AN           8/AN             5/AN                 5/AN                       
(1-8)          (9-16)           (17-21)              (22-26)                    
2------------- 3--------------- 4------------------- 5-----------------------   
00000001       LDSE95           CFDPL                     
00000002       LDSE95           DAST                     
00000003       LDSE95           ASDSD                     
00000004       LDSE95           WWEBD                     
00000005       LDSE95           AWFBD                     
00000006       LDSE95           SERWR                     
00000007       LDSE95           AQFTS                     
00000008       LDSE97           SERWR                     
00000009       LDSE97           SERWR                     
00000010       LDSE97           SERWR                     
00000011       LDSE97           SERWR                     
00000012       LDSE97           SERWR                     
00000013       LDSE97           SERWR                     
00000014       LDSE97           SERWR                     
00000015       LDSE95           SDFDE                     
00000016       LDSE95           APEER                    
00000017       LDSE95           EFGGE                     
 ENTER FMT (FORMATTED MODE), CHAR (CHARACTER MODE),  UNFMT (UNFORMATTED MODE)   
    

type CHAR on command line
Following screen will be displayed without showing the field name and lengths



     File-AID - Browse - AYS.VXXXXSW47.XXX.XXX.XXXXREAD -------------------- COL 1  79
 COMMAND ===>                                                  SCROLL ===> PAGE
00000001 LDSE95  APUPL     000424108                            SC  0  1N    343
00000002 LDSE95  APRST     00094                   B2539016CF999SC  0  IN    268
00000003 LDSE95  APRBD     000                                  SC  0  1N    273
00000004 LDSE95  APRBD     000                                  SC  0  2N    574
00000005 LDSE95  APRBD     000                                  SC  0  JN    475
00000006 LDSE95  SERWR     000                                  SC  0  JN    456
00000007 LDSE95  SERWR     000                                  SC  0  JN    343
00000008 LSPA97  SERWR     000                                  SC  0  I     645
00000009 LSPA97  SERWR     000                                  SC  0  I     645
00000010 LSPA97  SERWR     000                                  SC  0  I     645
00000011 LSPA97  SERWR     000                                  SC  0  I     645
00000012 LSPA97  SERWR     000                                  SC  0  2N    321
00000013 LSPA97  SERWR     000                                  SC  0  2N    321
00000014 LSPA97  SERWR     000                                  SC  0  IN    101
00000015 LDSE95  SERWR     000                                  SC  0  IN    503
00000016 LDSE95  UOHMN   000                                  SC  0  IN    190
00000017 LDSE95  VBNFG     000                                  SC  0  IN    333
00000018 LDSE95  YYHRG     000                                  SC  0  IN    420
00000019 LDSE95  GHJGH     000211901                            SC  0  JN    777
00000020 LDSE95  ASDFD     000211901                            SC  0  IN    224
00000021 LDSE95  DSFGR    000                                  SC  0  I     117
 ENTER FMT (FORMATTED MODE), VFMT (VERTICAL FORMAT), UNFMT (UNFORMATTED MODE)      


 Even If you go to in  BROWSE mode , you will get same screens as above 
 (option 1 from FILE-AID main menu) 
 
  Other Useful Commands
 
 HEX ON      - The data will be displayed in hexa decimal format.
               Usaually, it will be used to see COMP-3 values in the data set.
 
               Syntax -  HEX ON 
                           
 
 HIDE        - This command is used to hide some/all columns
 
               Syntax  - HIDE    <FIELD NUMBER>[-<FIELD NUMBER>]                                   
 
               
               Example - HIDE  1-3
                         Field1, Field2, Field3 will simply disappear from view
 
 
 DISPLAY    - To include or exclude specific items from display or alter the display 
              format of data items
 
              Syntax -  DISPLAY  <FIELD NUMBER>[-<FIELD NUMBER>]  [ON/OFF]

Primary Option Menu in File-Aid

2012-02-29T19:54:00.001+05:30

BROWSE/EDIT MODE - INITIAL DATA DISPLAY MODE

Four styles of data display are available when viewing your data file

records: C (Character), F (Formatted), V (Vertical format), U (Unformatted).

The MODE field lets you choose the display style you want to see first.

After the initial display, you use commands (CHAR, FMT, VFMT, UNFMT) to

switch your display mode as often as you like. Valid MODE values,

switching commands and restrictions are as follows:

C CHARACTER - Full screen ISPF-like display of records, one record per

line. Overtype data to make changes. Use HEX command to view hex

values. Use FMT command to switch to formatted mode, VFMT to switch

to vertical formatted mode, UNFMT command to switch to unformatted

mode. Use line and primary commands to work with data.

V VERTICAL - Requires a single record layout only. Like character, a

full screen display of data, one record per line, but data is described by the record layout provided. Use CHAR to switch to character mode, FMT to switch to formatted mode, UNFMT to switch to unformatted mode. Use HEX command to view hex values.