|
| |
| |
| |
|
|
|
| Mainframe230 |
| Entire mainframe world,plow your Maniframe knowledge in single site and also mainframe interveiw question and answers,entire mainframe jobs information |
| Language: English |
| RSS Feeds for this Blog |
|
Statistics |
| Unique Visitors: 320 |
| Total Unique Visitors: 1231372 |
| Visitors Out: 2408 |
| Total Visitors Out: 4089 |
|
|
|
| |
|
|
| |
|
| What is Difference between TSQ & TDQ? |
| 2010-11-11 06:02:25 |
(1) In Temporary Storage Queues Data is read randomly,
While in Transient Data Queues data must be read
sequentially.
(2) In a TSQ data can be read any number of
times as it remains in the queue until the entire Queue is
deleted. In TDQ data item can be read once only. To reuse
the TDQ it must be closed and reopened.
(3) Data can be
changed in TSQ, but not in TDQ.
(4) TSQ can be written to
Auxiliary or Main Storage, while TDQ is written to Disk.
Temporary storage is a holding place, while Transient data
is always associated with destination.
(5) TSQ name is
defined dynamically, while a TDQ name need to be defined in
the DCT. Note: An application uses TSQ 's to pass info'
from task to task, while a TDQ to accumulate records before
processing or send data for external use, such as a print
operation or other.
...
|
| |
|
| What is use of FREEKB? |
| 2010-11-11 05:30:59 |
In cics, FREEKB is used to free the keyboard when it gets locked in an transaction. This site is highly recommended and vastly useful.
...
|
| |
|
| SQL Important Questions And Answers |
| 2010-11-09 07:49:41 |
SQL Questions And AnswersWhat is an Entity?
The basic data item stored in database is called entity. An entity can be any object, item, place, person, concept, or activity about which data is stored.What is an attribute?
An attribute is a property of an entity. It describes a part of an entity. Entity could have one or more attributes.What is ER diagram?
An Entity Relationship Diagram is diagrammatic representation of the logical structure of a database system.Describe the concept of keys.
Candidate keyAn attribute that uniquely identifies a row is called candidate key. It is also called das surrogate key.Primary keyA candidate key that you choose to identify rows uniquely is called a primary key.Alternate keyIf there are multiple candidate keys in a table, the candidate keys that are chosen as primary key are called the alternate keys.Composite keyWhen the key that uniquely identifies the rows of a table is made up of more than one attribute, it is called as a composite ...
|
| |
|
| How can the SOC7 error be solved? |
| 2010-11-09 00:06:39 |
1)by using XPEDITER.
2)Going behind the reasons causing Soc7 in working -storage.
3)The most preferable one is to get the value of offset in compile list,getting this offset then find this offset's corresponding value in your pgm.It will take you straight to the line causing SOC7.
NOTE:
S0C7 is a DATA EXCEPTION Error. which caused due to use of wrong data in the program. Such as use of alphabets in an arithmetic expression.
For solving the S0C7 error first you find out the offset value in joblog for the perticular abend. Mapping that offset value to the lines od codes you find the area exactly where the error occured while processing.
...
|
| |
|
| RESETBR Command in cics |
| 2010-11-08 04:00:49 |
The RESETBR commandEXEC CICS RESETBR DATASET(file-name) RIDFLD(data-area) [ RRN | RBA ] [ GTEQ | EQUAL ] [ KEYLENGTH(data-value) [ GENERIC ] ] [ REQID(data-value) ] [ SYSID(name) ]END-EXEC
OptionsDATASET Specifies the file name as defined using CEDA DEFINE FILE(file-name) GROUP(group-name)
RIDFLD For a KSDS specifies the key of the record where the browse Will start. For a RRDS it specifies the relative record number and for an ESDS it specifies the RBA (PIC S9(8) COMP). If RRN or RBA is not specified, key is assumed.
RRN Specifies that the file is a RRDS and the RIDFLD shou...
|
| |
|
| READNEXT Command and READPERV Command in cics |
| 2010-11-08 03:57:46 |
The READNEXT commandEXEC CICS READNEXT { DATASET(name) | FILE(name) } { INTO(data-area) | SET(pointer-ref) } [ LENGTH(data-area) ] RIDFLD(data-area) [ KEYLENGTH(data-value) ] [ RBA | RRN ] [ REQID(data-value) ] [ SYSID(name) ]END-EXEC
Options DATASET or FILE Specifies a 1 to 8 character name for the dataset as specified using CEDA DEFINE FILE(name)
INTO The target data area
SET Specifies a pointer data item (or register) to hold the address of the data record
LENGTH Specifies in a half word PIC S9(4) COMP field. This is an input / output field. On input it specifies the length of the d...
|
| |
|
| Browser commands in cics - STARTBR Command |
| 2010-11-08 03:52:06 |
The STARTBR commandEXEC CICS STARTBR DATASET(file-name) RIDFLD(data-area) [ RRN | RBA ] [ GTEQ | EQUAL ] [ GENERIC ] [ KEYLENGTH(data-value) ] [ REQID(data-value) ] [ SYSID(name) ]END-EXEC
Options:DATASET Specifies the file name as defined using CEDA DEFINE FILE(file-name) GROUP(group-name)
RIDFLD For a KSDS specifies the key of the record where the browse Will start. For a RRDS it specifies the relative record number and for an ESDS it specifies the RBA (PIC S9(8) COMP).
RRN Specifies that the file is a RRDS and the RIDFLD should be interpreted as a relative record numbe...
|
| |
|
| What is Browser in cics? |
| 2010-11-08 03:48:08 |
BrowsingAccessing files sequentially is called browsing. The commands that are needed for browsing are:-
STARTBRREADNEXTREADPREVRESETBRENDBR
You can browse a KSDS, RRDS or ESDS. Browsing a KSDS is on key sequence. For an RRDS it is based on relative record numbers. For an ESDS it is based on RBA.
...
|
| |
|
| FILEAID Tool Important Tips |
| 2010-11-07 23:20:54 |
TIP # 1
FILEAID
The Easiest and Coolest way to locate bad data is thru File-Aid's FIND command.
1.OPEN the file in FILE-AID (in either browse or edit mode)
2.XREF with COPYBOOK.
3.Use FMT mode
4.Then issue ,
F /field-name INVALID
or
F /field-number INVALID
The control will take you to the first invalid data record for the given field.
e.g.,
The FILE has 3 fields namely NAME,AGE,COUNTRY.
If you want to find the invalid data in the age field, then issue
F /2 INVALID
TIP #2
FILEAID
We always face a s ituation such that when we have opened a File in FI LEAI
D Brows e mode but later wished it was EDI T Mode and vice ver sa. S o in
this s ituation, what we do is come out of the brows e mode and again open in
edit mode and vice ver sa. But ther e is a cool command available in FI LE-AI D
to help us in this type of s ituation.
I f u r in Brows e Mode and want to change it into EDI T Mode , in the Line
Command is sue
COMMAND = = > GO EDI T
I f u r in EDI T Mode and want to change it into ...
|
| |
|
| CICS Important Tips |
| 2010-11-07 23:15:20 |
TIP # 1 CICS
Use CALLs instead of LINKs in CICS
EXEC CICS LINK
- establishes a new run unit
- sets up environment
- Does CICS table-search
- For all this activities, it executes 1400 machine code instructions
CALL
- It executes around 12 machine code instructions
Just replacing EXEC CICS LINK with CALL statement on a case study, it was found that
Internal Transaction Response time improved 23 - 78 %
Total CPU Time improved 15 - 23 %
Dynamic storage use improved 11 - 30 %
* CALL used in the study is STATIC CALL . COBOL refered here is VS COBOL II
TIP # 2 CICS
You can use a COBOL CALL statement to call only a VS COBOL II or an Assembler language
program in the same load module as the calling program.
For calls to programs written in languages other than VS COBOL II, including other versions of
COBOL, you need to use the commands EXEC CICS LINK or EXEC CICS XCTL.
TIP # 3 CICS
Do you know how CICS was called initially ??
PUCICS!!!
PUCICS stands for Public Utilities Cust...
|
| |
|
| |
 |
