DSNT361I *DISPLAY DATABASE SUMMARY* report-type-list

The DSNT361I message displays output from the DISPLAY DATABASE command. The output consists of information about the requested set of databases, table spaces, and index spaces. For more information, see -DISPLAY DATABASE command (Db2).

The output from this DISPLAY DATABSE command has the following general structure. In your output, some of these lines might be included more than once and some might not be included at all. Which lines are included depends on the situation, as noted in the descriptions of the variables in this output.

DSNT360I - ***********************************************************
DSNT361I - *  DISPLAY DATABASE SUMMARY
           *    report-type-list
DSNT360I - ***********************************************************
DSNT362I -     DATABASE = database-name  STATUS = database-status
               DBD LENGTH = dbd-length
DSNT363I - PHYSICAL ERROR PAGE RANGE FOR DATA SET data-set-name  LOW=lowphy, HIGH=hiphy
DSNT397I -

After line DSNT397I, information about the requested table spaces, index spaces, and partitions is displayed. The general format depends on which options are specified in the DISPLAY DATABASE command, as follows.

OVERVIEW option

When the OVERVIEW option is specified on the DISPLAY DATABASE command, the output that follows line DSNT397I has the following general format:

NAME     TYPE PARTS
-------- ---- -----
space    type parts
space    type parts
space    type parts

CLAIMERS option

When the CLAIMERS option is specified on the DISPLAY DATABASE command, the output that follows line DSNT397I has the following general format:

NAME     TYPE PART  STATUS            CONNID   CORRID       CLAIMINFO
-------- ---- ----- ----------------- -------- ------------ --------
space    type part  status            conn-id  corr-id      claims
----                status-2          pages-2
     -                   MEMBER NAME member-name
space    type part  status            conn-id  corr-id      claims
     -                   MEMBER NAME member-name
space    type part  status            conn-id  corr-id      claims
DSNT352I - AGENT TOKEN agent token

USE option

When the USE option is specified on the DISPLAY DATABASE command, the output that follows line DSNT397I has the following general format:

NAME     TYPE PART  STATUS            CONNID   CORRID       USERID
-------- ---- ----- ----------------- -------- ------------ --------
space    type part  status            conn-id  corr-id      user-id 
----                status-2          pages-2
     -                   MEMBER NAME member-name
space    type part  status            conn-id  corr-id      user-id 
     -                   MEMBER NAME member-name
space    type part  status            conn-id  corr-id      user-id 

LOCKS option

When the LOCKS option is specified on the DISPLAY DATABASE command, the output that follows line DSNT397I has the following general format:

NAME     TYPE PART  STATUS            CONNID   CORRID       LOCKINFO
-------- ---- ----- ----------------- -------- ------------ ---------
space    type part  status            conn-id  corr-id      lock
----                status-2          pages-2
     -                   MEMBER NAME member-name
space    type part  status            conn-id  corr-id      lock
     -                   MEMBER NAME member-name
space    type part  status            conn-id  corr-id      lock
DSNT352I - AGENT TOKEN agent token

LPL option

When the LPL option is specified on the DISPLAY DATABASE command, the output that follows line DSNT397I has the following general format:

NAME     TYPE PART  STATUS            LPL PAGES
-------- ---- ----- ----------------- ------------------
space    type part  status            LPL-pages
----                status-2          pages-2
space    type part  status            LPL-pages
space    type part  status            LPL-pages

When WEPR, LOCKS, LPL, CLAIMERS, and USE are omitted

When the DISPLAY DATABASE command is issued without the WEPR, LOCKS, LPL, CLAIMERS, and USE options, the output that follows line DSNT397I has the following general format:

NAME     TYPE PART  STATUS            PHYERRLO PHYERRHI CATALOG  PIECE
-------- ---- ----- ----------------- -------- -------- -------- -----
space    type part  status            lo-page  hi-page  cat-name piece
----                status-2          pages-2
space    type part  status            lo-page  hi-page  cat-name piece
     -THRU part
space    type part  status            lo-page  hi-page  cat-name piece

The DISPLAY DATABASE output ends with the following lines:

******* DISPLAY OF DATABASE name action ****************************
DSN9022I - DSNTDDIS 'DISPLAY DATABASE' NORMAL COMPLETION

#dsnt361i__d2384e2972 might also be included in your output if a problem occurred.

report-type-list

The options that were specified on the DISPLAY DATABASE command. Each option is delimited by a space. Possible values include one or more of the following options:

ACTIVE

The output includes all allocated databases.

GLOBAL

The output includes all requested database information.

report-type-list is GLOBAL if the DISPLAY DATABASE command does not include the ACTIVE, DISABLED, and RESTRICT options.

LOCKS

The output includes all connection identifiers and correlation identifiers of all applications that are holding, retaining, or waiting for locks on the specified table spaces or index spaces.

RESTRICT

The output includes all databases with restricted usage. Databases in RO and started UT mode are listed.

USE

The output includes the connection identifiers and correlation identifiers of all allocated applications.

CLAIMERS

The output includes the connection identifiers and correlation identifiers of all applications that are holding claims on the specified database.

LPL

The output includes the page number ranges of the pages that are included in the logical page list for the table space or index space.

OVERVIEW

The output includes all table spaces and index spaces that are contained within the databases that are specified.

database-name

The name of the database.

database- status

The status of the database. The value can be one or more of the following strings delimited by a comma. The maximum length of the string is 18 characters.

RO

The database is started for read activity only.

RW

The database is started for read and write activity.

STOP

The database is stopped.

STOPP

A stop operation for this database is in progress, is pending or has failed.

If the object seems to be in a persistent STOPP status, check whether the stop operation is still in progress. You can check this progress by looking at message DSNI003I or the output from the DISPLAY THREAD command with the TYPE(SYSTEM) option.

• Message DSNI003I lists objects that could not be stopped.
• In the DISPLAY THREAD output, look for message DSNV501I with STOP DATABASE listed as the command that is executing. If you see one of these messages, the STOP DATABASE command is still in progress for the thread that is identified in DSNV402I.

If the STOP operation timed out or failed, resolve the error by using the START DATABASE command.

For more information, see:

• -DISPLAY THREAD command (Db2)
• -START DATABASE command (Db2)
• DSNI003I

UT

The database is started for utility processing only.

UTRO

A utility that allows only RO access is in process on the database. If the utility was canceled before the object was drained, the object can allow SQL access, because the object was not altered by the utility.

UTRW

A utility that allows RW access is in process on the database.

UTUT

A utility that allows only UT access is in process on the database. If the utility was canceled before the object was drained, the object can allow SQL access, because the object was not altered by the utility.

dbd-length

The length of the database descriptor (DBD) in bytes.

DSNT363I - PHYSICAL ERROR PAGE RANGE FOR DATA SET data-set-name LOW=lowphy, HIGH=hiphy

This line lists any physical I/O errors on a data set. This information is displayed if such errors exist and the SPACENAM option was specified on the DISPLAY DATABASE command.

This message refers to physical pages in a data set that supports a page set. Page sets (table spaces or index spaces) are made up of supporting data sets. Physical pages are pages in supporting data sets. Physical pages are numbered from the beginning of the particular data set in which they reside.

data-set-name

The name of the data set with errors.

lowphy

The first page number in the range of physical pages that were being read when the I/O errors occurred. These physical pages are within the identified data set.

hiphy

The last page number in the range of physical pages that were being read when the I/O errors occurred.

space

The table space name, index space name, or table object ID (OBID).

The line that begins with space describes the status of a table space or index space in the specified database. (The database is listed in the preceding DSNT362I line.) This line is repeated as many times as needed to satisfy the DISPLAY DATABASE request.

The line that begins with space, the header line that precedes it, and the DISPLAY OF DATABASE line are always produced with a multiple line WTO and are never interrupted.

type

The type of object. type can have one of the following values:

TS

Table space

IX

Index space

LS

LOB table space

TB

Table

WD

FL 508 A partition-by-growth (PBG) table space that was created with the FOR DGTT option.

WF

FL 508 A work file table space that is not a PBG table space.

WS

FL 508 A table space that was created with the FOR SORT option.

XS

XML table space

If the object is involved in cloning, type is appended with a B (for a base object) or a C (for a clone object) and a data set instance number. For example, a base object that is involved with cloning has B2 appended to the type indicator if it is represented by an instance number 2 data set. A base object that is no longer involved with cloning has no suffix.

Look at the CLONE column in the SYSIBM.SYSTABLESPACE catalog table to determine whether a table space and its objects are involved in cloning. A value of Y in the CLONE column indicates that cloning is active. The value in the INSTANCE column indicates the data set instance number for the current base objects.

For more information, see SYSTABLESPACE catalog table.

parts

The number of partitions in the table space, index space, LOB table space, or XML table space. This value is blank for a simple table space, simple index space, or segmented table space.

part

The partition number. This value is blank for a nonpartitioned table space or an index on a nonpartitioned table space. For nonpartitioned secondary indexes, this value is the logical partition number preceded by the character L (for example, L0001). For data-partitioned secondary indexes, this value is preceded by the character D (for example, D0001).

If this column is blank or contains L* for a partitioned object, the data that is reported in that line of output applies to the entire table space or index object.

status

The status of the table space or index space. Possible values are blank, or one or more of the following values, delimited by commas. The maximum length of the string is 17 characters.

ACHKP

The table space is in auxiliary CHECK-pending status. See Auxiliary CHECK-pending status.

ARBDP

The index space is in advisory REBUILD-pending status. This status is set when indexes with varying length columns are changed from VARYING NO to VARYING YES.

AREO*

The table space is in advisory REORG-pending status. See REORG-pending status.

AREST

The table space, index space, or physical partition of a table space or index space is in an advisory restart-pending status. If backout processing for the object is not already in progress, start backout processing. Either issue the RECOVER POSTPONED command or restart the Db2 subsystem with the subsystem parameter LBACKOUT set to AUTO.See LIMIT BACKOUT field (LBACKOUT subsystem parameter).

AUXW

The table space is in auxiliary warning status. See Auxiliary warning status.

CHKP

The table space or partition within a table space is in CHECK-pending status. See CHECK-pending status.

COPY

The table space or partition within a table space is in COPY-pending status. See COPY-pending status.

DBETE

Either one of the following situations exist:

• The table space, partition within a table space, index space, index partition, or logical index partition is in DBETE status. The error occurred when the DBET states were being modified during log apply or must-complete processing. This condition prohibited Db2 from successfully updating the DBET states.
• Db2 encountered an unexpected page set access error during restart, unrelated to processing a DBET exception state.

See DBETE status.

GRECP

The table space, table space partition, index space, or index space partition is in group buffer pool RECOVER-pending status. See Group buffer pool RECOVER-pending status and Data sharing status descriptions.

This status value is valid only on spaces. It does not apply to databases.

ICOPY

The object is in informational COPY-pending status. See Data sharing status descriptions and Informational COPY-pending status.

LPL

The object has pages or ranges of pages that are unavailable because of logical or physical damage. See Removing pages from the logical page list.

LSTOP

The logical partition is stopped.

PRO

The table space partition is in Persistent Read Only restricted status. See PRO restricted status..

PSRBD

The index space is in page set REBUILD-pending status. See REBUILD-pending status.

RBDP

The index space, index partition, or logical index partition is in REBUILD-pending status. See REBUILD-pending status.

For logical partitions, the RBDP status can be displayed as RBDP*.

RBDP*

The object is in REBUILD-pending status. See REBUILD-pending status..

The entire index is inaccessible to SQL applications. However, only the logical partition must be rebuilt.

RECP

The table space, table space partition, index space, index partition, or logical index partition is in RECOVER-pending status. See RECOVER-pending status.

REFP

The table space, table space partition, index space, or index space partition is in REFRESH-pending status. See REFRESH-pending status.

REORP

The table space or table space partition is in REORG-pending status. See REORG-pending status.

RESTP

The object is in the restart-pending status. See Restart-pending status.

RO

The table space, table space partition, index space, or index space partition is started for read-only activity.

RW

The table space, table space partition, index space, or index space partition is started for read and write activity.

STOP

The able space, table space partition, index space, or index space partition is stopped.

STOPE

The table space or index space was implicitly stopped because the log RBA in a page had a problem. Message DSNT500I or DSNT501I is issued when the error is detected to indicate the inconsistency. See DSNT500I or DSNT501I .

STOPP

A stop is pending for the database, table space, table space partition, index space, or index space partition.

UT

The table space, table space partition, index space, or index space partition is started for utility processing only.

UTRO

A utility that allows only RO access is in process on the table space, table space partition, index space, or index space partition.

UTRW

A utility that allows RW access is in process on the table space, table space partition, index space, or index space partition.

UTUT

A utility that allows only UT access is in process on the table space, table space partition, index space, or index space partition.

WEPR

This object has pages or ranges of pages that are unavailable because of physical damage. To reset this status, use either the RECOVER utility with the ERROR RANGE option or the LOAD utility with the REPLACE option.

If the status for a nonpartitioned index is blank, the status information is displayed at the logical partition level. If type is TB, status is blank.

In the final summary line for partitioned objects where space is either blank or L*, status can be only blank, DBETE or DBETE,RECP.

status-2

More statuses for the listed object. status-2 is displayed if all of the status information cannot fit on the preceding line.

THRU part

This line indicates that a range of partitions share the same status information.

part

The last partition in a range of partitions that share the same status information as the partition listed in the preceding line.

This line can be displayed only when the preceding line does not contain information for the following values:

• lo-page
• hi-page
• cat-name
• piece

conn-id

A connection identifier for the thread. conn-id can have one of the following values:

BATCH

The thread is from a batch region.

TSO

The thread is from a TSO terminal.

UTILITY

The thread is from a utility.

IMS identifier

The thread is from an IMS terminal.

CICS identifier

The thread is from a CICS® terminal.

CONSOLE

The thread is from the console.

the connection name of the thread at the requesting location

The thread is a distributed database access thread that uses system-directed access and or application-directed access from a Version 3 or later Db2 requester.

SERVER

The thread is a distributed database access thread that uses application-directed access from a non-Db2 requester or from a Db2 Version 2 Release 3 requester.

If the DISPLAY DATABASE command included the LOCKS option and the displayed lock is a P-lock or a retained lock (either L-lock or P-lock), a conn-id value is not displayed. For page set P-locks, the Db2 member name is used to identify the lock.

corr-id

A correlation identifier of the thread that is associated with the space name. corr-id can have one of the following values:

job name

The JCL job name. This value is displayed if the thread is from a batch region.

TSO logon identifier

The TSO logon user ID. This value is displayed if the thread is from a TSO terminal.

pst#.psbname

This value is displayed if the thread is from an IMS terminal.

entry ID.thread number.tran id

This value is displayed if the thread is from a CICS terminal. See Troubleshooting Db2 from CICS.

CONSOLE

This value is displayed if the thread is from the console.

0nn

This value is displayed if the thread is for a system agent. nn is a number.

028.DBAAnn

This value is displayed if the thread is a distributed database access thread that is being created. nn ranges from 01 to 99. This value indicates that the database access agent (DBAA) is in its connection processing. This processing consists of establishing the DBAA thread and validating and verifying the user's ID.

All RACF® requests are serialized on a single Db2 RACF service task, which might increase the validation time when multiple DBAAs are being created concurrently.

the correlation ID of the thread at the requesting location.

This value is displayed for an existing distributed database access thread that uses system-directed access or application-direct access from a Db2 requester.

extnam

The first 12 characters in the DDM external name (EXTNAM) parameter of the DDM EXCSAT command that is received as part of the SQL CONNECT. This value is displayed for an existing distributed database access thread that uses application-directed access from a requester that is not Db2.

If the DISPLAY DATABASE command included the LOCKS option and the displayed lock is a P-lock or a retained lock (either L-lock or P-lock), a corr-id value is not displayed. For page set P-locks, the Db2 member name is used to identify the lock.

claims

The type and duration of currently held claims. The claim consists of a claim class descriptor and a claim duration descriptor.

The claim class descriptor has one of the following values:

CS

Cursor stability claim class

RR

Repeatable-read claim class

WR

Write claim class

The claim duration descriptor describes the duration of the claims and has one of the following values:

A

The claim is held until deallocation.

C

The claim is held until the next commit point.

H

The claim is held across commit.

agent token

Holders or claimers. This information is displayed if the LOCKS option or the CLAIMERS option was specified on the DISPLAY DATABASE command and the agent information is available.

You can cancel the lock holder or claimer by using the CANCEL THREAD command. Alternatively, you can gather more information about the holder or claimer by using the DISPLAY THREAD command.

user-id

The user ID, which can be one of the following values:

TSO logon identifier

The TSO logon user ID. This value is displayed if the thread is from a TSO terminal.

AXBUSER

This value is displayed if the thread is from an IMS message-driven region and RACF is used.

sign-on ID or LTERM

The user ID that was used to sign on the terminal that is attached to IMS or the logical terminal (LTERM) value. This value is displayed if the thread is from an IMS message-drive region.

PSB name

The program specification block (PSB) name. This value is displayed if the thread is from an IMS nonmessage-driven region and RACF is not used.

user-id, term id, or tran id

The user ID, terminal ID, transaction ID, or other ID, as specified in the resource control table (RCT) if the thread is from CICS.

MEMBER NAME member-name

This line is displayed for each thread in a data sharing environment.

member-name

The name of the Db2 member that is accessing this object.

If the characters (CO) follow the member name, this member is the castout owner for the page set or partition. The castout owner for a page set or partition is the Db2 member that is responsible for doing all of the castout I/O for that page set or partition.

lock

A description of the following types of locks and the duration of the locks:

• Transaction locks (also called L-locks) are identified by the connection ID and correlation ID of their corresponding agents.

  Multiple locks that are held by an agent are listed on multiple lines of the report followed by any locks on which the agent is waiting.

• Physical locks (P-locks) and retained locks are identified by their Db2 data sharing member names.

  Multiple P-locks or retained locks that are held by a Db2 data sharing member are listed on multiple lines of the report. The output then lists any locks on which the member is waiting.

lock consists of the following information:

lock status-lock state,lock type,lock duration

lock status

The status of the lock, which can be one of the following values:

H

The lock is held by the agent or the Db2 member.

W

The agent or the member is waiting for the lock.

R

The lock is retained.

lock state

The mode of the lock as follows:

• For L-locks and drain locks, lock state has one of the following values:

  IS

  A lock with read intentions.

  IX

  A lock with update intentions.

  S

  A lock with read-only capability.

  U

  A lock with update capability.

  SIX

  A table space or table lock with a protocol that does not lock a page while reading it, but does lock the page with update intention while updating it.

  X

  An exclusive lock.

• For L-locks on LOB table spaces, lock state has one of the following values:

  IS

  A lock with intent to reserve space within the LOB table space

  IX

  A lock with intent to insert LOBs in the LOB table space.

  S

  A lock that reserves space within the LOB table space.

  SIX

  A lock that allows the owner to read and update LOBs.

  X

  An exclusive lock.

• For P-locks, lock state has one of the following values:

  IS

  This Db2 member has R/O interest. The page set or partition is group buffer pool (GBP) dependent.

  IX

  This Db2 member has R/W interest. The page set or partition is GBP-dependent.

  S

  This Db2 member has R/O interest. The page set or partition is not GBP-dependent.

  SIX

  This Db2 member has R/W interest. The page set or partition is GBP-dependent.

  NSU

  This Db2 member has R/W interest. The page set or partition is GBP-dependent.

  X

  This Db2 member has R/W interest. The page set or partition is not GBP-dependent.

lock type

lock type describes the type of locking and has one of the following values:

S

A table space L-lock

T

A table L-lock

C

A cursor-stability read drain lock

R

A repeatable-read drain lock

W

A write drain lock

P

A partition L-lock

PP

A page set or partition P-lock

U

A utility and SQL mass delete lock

lock duration

lock duration describes the duration of the lock as follows:

• If lock status has a value of H, lock duration has one of the following values:

  A

  The lock is freed at deallocation.

  C

  The lock is freed at commit.

  H

  The lock is freed when all cursors are closed.

  M

  The lock is freed by the system.

  P

  The lock is freed when the plan is complete.

  I

  The lock is a page set or partition P-lock. It is released when the page set or partition data set is closed.

• If the lock status has a value of W, lock duration is a two-digit number that indicates the position of the waiter in the lock waiting queue for the local Db2 system.

  After the agent acquires the lock, the lock status value becomes H, and the lock duration value becomes one of the lock duration values that are listed for a lock status of H.

• For a P-lock, the lock is owned by the system, not the user, and its duration is not related to the duration of the locks that are owned by the user.
• Retained locks do not have a lock duration.

No explicit index space locks exist. However, all index spaces on tables are implicitly locked with transaction locks at the same level as the table spaces that contain those tables. P-locks are acquired by Db2 on index spaces and on table spaces.

LPL-pages

The pages in the specified space that are unavailable because of logical or physical damage.

pages-2

More pages that are in the logical page list (LPL) for the listed object. pages-2 is displayed if the list of pages cannot fit on the preceding line.

LPL pages can be listed in one of the following two formats:

• Single pages, which are represented by the page number
• A range of pages, which are represented by the starting page number followed by a dash and the ending page number in the range

lo-page

A hexadecimal number that identifies the lowest page number that contains a physical I/O error.

This value is displayed only if a data set for the specified table space or index space has physical I/O errors. Otherwise, if no physical I/O errors exist, this column is blank.

hi-page

A hexadecimal number that identifies the highest page number that contains an I/O error.

This value is displayed only if a data set for the specified table space or index space has physical I/O errors. Otherwise, if no physical I/O errors exist, this column is blank.

cat-name

The catalog that owns the data set with the I/O errors.

This value is displayed only if a data set for the specified table space or index space has physical I/O errors. Otherwise, if no physical I/O errors exist, this column is blank.

piece

An integer number that identifies the piece within the table space or index space with the error.

This value is displayed only if a data set for the specified table space or index space has physical I/O errors. Otherwise, if no physical I/O errors exist, this column is blank.

You can use the piece number to construct the name of the data set for the space that contains the physical error as follows:

cat-name.DSNDBC.database-name.
space-name.I0001.Axxxx

Where xxxx is the piece number plus one and database-name is the name that is displayed in the preceding DSNT362I message. If the table space or index space is partitioned, the partition number is equal to the piece number plus one.

DISPLAY OF DATABASE name action

This line indicates the end of the DISPLAY DATABASE output.

name

The name of the database.

action

An indication of whether the output is complete. action can have one of the following values:

CONTINUES

The remaining table space and index space names within this database are continued to a new display.

TERMINATED

The remaining table space and index space names within this database are terminated.

ENDS

The display for this database is complete.

Error messages for DISPLAY DATABASE commands

DSNT399I INVALID space-name

See DSNT399I.

DSNT602I NO SPACES FOUND

See DSNT602I.

DSNT603I spacetype name NOT type

See DSNT603I.

DSNT604I NO INFORMATION AVAILABLE

See DSNT604I.