Previous Topic: VMJAREC3: CARDTYP = 'AC' (TSAF)

Next Topic: VMJAREC3: CARDTYP = 'AE' (SFS Usage)

VMJAREC3: CARDTYP = 'AD' (SQL/DS DBSPACE)

Field Name

Start

Length

Display

Type

Default Column Header

Description

SQLOWNID

29

8

 

A/N

SQL/DS OWNER ID

SQL owner identifier; this can be the same as user ID

Identifies the owner of the DBSPACE

SQLDBNAM

37

8

 

A/N

DATABASE NAME

Name of the SQL database

SQLSPOOL

45

2

99909

BINP

STORAGE POOL NUMBER

Storage pool number

SQLSTYPE

47

 

XX

BIT

DBSPACE TYPE

The type of DBSPACE. Values:

  • X'01'=Private; only the owner can access this information.
  • X'02'=Public; anyone can access this information.

SQLSNAML

48

1

XX

BIT

DBSPACE NAME LEN

The length of the DBSPACE name

SQLSNAME

49

18

 

A/N

DBSPACE NAME

The name of the DBSPACE

SQLSPACE

67

2

99909

BINP

DBSPACE NUMBER

A number assigned to the DBSPACE to uniquely identify it

SQLPAGES

69

4

9,999,999,909

BINS

DBSPACE PAGES OWNED

Pages of storage owned

SQLDAYS

73

2

99909

BINP

DAYS OWNED

The number of days you are charged for owning the DBSPACE

SQLSTOR$

185

4

99,999,990.99

BINS

COST FOR PAGES OWNED

Charge for pages owned