Author |
Message |
Topic: Check the performance of a running SQL query? |
R.Nickel
Replies: 3
Views: 2039
|
Forum: Database Posted: Wed Sep 29, 2004 6:49 pm Subject: Check the performance of a running SQL query? |
Does your shop have strobe ? |
Topic: how can a programmer avoid deadlocks in cics ? |
R.Nickel
Replies: 4
Views: 2690
|
Forum: CICS and Middleware Posted: Tue Mar 09, 2004 10:39 pm Subject: how can a programmer avoid deadlocks in cics ? |
Deadlocks occur because 2 programs are updating 2 or more databases, if program PGM1 updates DB1 and DB2 in that order and program PGM2 updates DB2 then DB1 then you have a potential for a Deadlock. e ... |
Topic: Alternate Index Definition for IAM files |
R.Nickel
Replies: 3
Views: 4083
|
Forum: CICS and Middleware Posted: Wed Sep 03, 2003 5:12 pm Subject: Alternate Index Definition for IAM files |
Amaresh,
The error appears to be SMS related, include a VOLUMES(????) in the DEFINE AIX
OWNER($IAM) is not mandatory.
Also a dumb question, is the base IAM? |
Topic: Alternate Index Definition for IAM files |
R.Nickel
Replies: 3
Views: 4083
|
Forum: CICS and Middleware Posted: Tue Sep 02, 2003 5:04 pm Subject: Alternate Index Definition for IAM files |
Amaresh,
What version of IAM are you using, and is AIX support installed(this is an OPTIONAL extra) |
Topic: COBOL and Table Handling |
R.Nickel
Replies: 4
Views: 3258
|
Forum: Application Programming Posted: Wed May 21, 2003 11:16 pm Subject: COBOL and Table Handling |
Subscripts MUST be comp/binary - otherwise they will converted to binary.
Indexes are used to access arrays SEQUENTIALLY in a defined sequence by 1,2 etc either forward or backward.
The compiler wi ... |
Topic: CISZ |
R.Nickel
Replies: 2
Views: 1949
|
Forum: Data Management Posted: Wed Apr 23, 2003 5:32 pm Subject: CISZ |
RECSIZE 9800 is larger than your CISZ of 8192 - vsam has adjusted to the 'next valid CISZ' . If you really want a CISZ of 8192 you must use spanned records but be aware of all the rules when using s ... |
Topic: PHYREC/TRK and PHYREC-SIZE |
R.Nickel
Replies: 6
Views: 5812
|
Forum: Data Management Posted: Tue Apr 22, 2003 12:28 am Subject: PHYREC/TRK and PHYREC-SIZE |
PHYREC-SIZE is not CISZ, it is a result caused by VSAMs' CISZ and the architecture of the device type, you only need to refer to the CISZ.
number of records per CISZ = TRUNC(CISZ/LRECL)
numbe ... |
Topic: PHYREC/TRK and PHYREC-SIZE |
R.Nickel
Replies: 6
Views: 5812
|
Forum: Data Management Posted: Mon Apr 21, 2003 11:18 pm Subject: PHYREC/TRK and PHYREC-SIZE |
PHYREC-SIZE is not CISZ, it is a result caused by VSAMs' CISZ and the architecture of the device type, you only need to refer to the CISZ.
CISZ of 6656 on a 3350 would create PHYREC-SIZE of 512, 72% ... |
Topic: PHYREC/TRK and PHYREC-SIZE |
R.Nickel
Replies: 6
Views: 5812
|
Forum: Data Management Posted: Mon Apr 21, 2003 5:06 pm Subject: PHYREC/TRK and PHYREC-SIZE |
1) recordsize(80 400) allows for individual records between 80 and 400 bytes(a bit like a VB file).
2) Correct.
3) Vsam in its wisdom in conjunction with the device (in your case a 3390) PHYSICALLY ... |
Topic: space optimization |
R.Nickel
Replies: 4
Views: 4018
|
Forum: Data Management Posted: Mon Mar 31, 2003 5:46 pm Subject: space optimization |
ksandy,
Set freespace for both CI's and CA's to zero, change your CISIZE to 18432( if you are not using extended format vsam datasets, which I don't think you are, and you use 3390's) space alloca ... |
Topic: Suggest me the correct Size and Type the variable |
R.Nickel
Replies: 4
Views: 2444
|
Forum: Application Programming Posted: Tue Feb 11, 2003 6:10 pm Subject: Suggest me the correct Size and Type the variable |
Ravikumar,
Try this
IN-ENTRY-NUMBER 1 7 N 2
IN-ENTRY# 9 1 B
W-ENTRY W 1 B
W-ENTRY = IN-ENTRY# OR X'F0'
IN- ... |
Topic: MSDB Database |
R.Nickel
Replies: 2
Views: 3425
|
Forum: Database Posted: Wed Jan 22, 2003 9:43 pm Subject: MSDB Database |
MSDB - Main Storage Data Base - Is a particular type of IMS Fastpath Data Base.
The whole database is kept in Storage, refer to IMS manuals for fuller explanation of pros & cons for use of this ... |
Topic: SYSIN DATA |
R.Nickel
Replies: 14
Views: 8078
|
Forum: Job Control Language(JCL) Posted: Thu Jan 09, 2003 5:51 pm Subject: SYSIN DATA |
For jobs that have already run you will not be able to see the data. It is gone! finished! Kaput!  |
Topic: SYSIN DATA |
R.Nickel
Replies: 14
Views: 8078
|
Forum: Job Control Language(JCL) Posted: Thu Jan 09, 2003 5:09 pm Subject: SYSIN DATA |
JSP,
Position the IEBGENER either just after the data is created or just before it is used. The output will be with the job just run so it cannot change after that, use SDSF and the contents as used ... |
Topic: SYSIN DATA |
R.Nickel
Replies: 14
Views: 8078
|
Forum: Job Control Language(JCL) Posted: Thu Jan 09, 2003 4:20 pm Subject: SYSIN DATA |
JSP,
Change the JCL, add an IEBGENER step and copy the 'Dynamic control card' which I assume is a temporary dataset to the same output class as your MSGCLASS and you can view/print as required. |
|