MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 22 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Check the performance of a running SQL query?
R.Nickel

Replies: 3
Views: 2039

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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! Crying or Very sad
  Topic: SYSIN DATA
R.Nickel

Replies: 14
Views: 8078

PostForum: 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

PostForum: 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.
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group