Chris Bartram writes


Someone refresh my ailing memory...

Is there some way (with FOS tools - don't have adager/et al :-( ) to look
at
a database/datasets and tell if DDX is enabled on the dataset(s)? And the
nifty things like initial-capacity, increment, maximum capacity?

Didn't see anything in a Query FO SETS...

I know DBUTIL shows me that it's ENABLED in the database, but I need to
know
set specifics...
-------------------------------------------------------------------------------------
Call "DBINFO" mode 205 and look at word 27 for on/off and the other words
for the other parameters in the return buffer

Mode 205: Set Capacity



Mode 205 is an extension of mode 202 with dynamic capacity expansion
information.



Qualifier

identifies the data set name or number for which the information is
requested.
Buffer

returns the following (each element is a halfword or two bytes):





Element
Contents
1-8
Data set name
9
One of the following set types followed by a blank:
M, A, D
10
Entry length
11
Blocking factor
12
0
13
0
14-15
Number of entries in set
16-17
Current capacity of set, including expansions
18-19
High-water mark
20-21
Maximum capacity
22-23
Initial capacity (primary capacity for master)
24-25
Incremental number of entries
26
Incremental percent
27
Dynamic capacity expansion flag (0 = off, 1 = on)


The data set name is left-justified and will be padded with blanks if the
name is shorter than 16 characters.
Mode 205 can be used for any master or detail data set with or without
dynamic capacity expansion capability.
Mode 205 allows users to obtain information on dynamic data set capacity
expansion programmatically. It is an extension of mode 202 to include
dynamic capacity expansion information such as maximum capacity, initial
capacity, incremental number of entries, incremental percent, and the
dynamic capacity expansion flag (0 for off and 1 for on) for the data set.

Michael Berkowitz / Project Manager
CGS / BlueCherry
213 614-1300 x269
[log in to unmask]

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *