リスト3 データベースのスナップショット

                          Database Snapshot

Database name                              = SAMPLE
Database path                              = C:\DB2\NODE0000\SQL00002\
Input database alias                       = SAMPLE
Database status                            = Active
Catalog database partition number          = 0
Catalog network node name                  =
Operating system running at database server= NT
Location of the database                   = Local
First database connect timestamp           = 02-20-2004 06:19:00.847979
Last reset timestamp                       =
Last backup timestamp                      =
Snapshot timestamp                         = 02-20-2004 06:23:17.252491

High water mark for connections       = 1                (MAXAPPLS)
Application connects                       = 1
Secondary connects total                   = 0
Applications connected currently      = 1                 (AVG_APPLS)
Appls. executing in db manager currently   = 0
Agents associated with applications        = 1
Maximum agents associated with applications= 1
Maximum coordinating agents                = 1

Locks held currently                       = 0
Lock waits                                 = 0
Time database waited on locks (ms)         = 0
Lock list memory in use (Bytes)       = 1000    (LOCKLIST and MAXLOCKS)
Deadlocks detected                         = 0
Lock escalations                      = 0         (LOCKLIST and MAXLOCKS)
Exclusive lock escalations            = 0          (LOCKLIST and MAXLOCKS)
Agents currently waiting on locks          = 0
Lock Timeouts                         = 0                (LOCKTIMEOUT)
Number of indoubt transactions             = 0

Total Private Sort heap allocated     = 0      (SHEAPTHRES and SORTHEAP)
Total Shared Sort heap allocated      = 0    (SHEAPTHRES_SHR and SORTHEAP)
Shared Sort heap high water mark      = 0   (SHEAPTHRES_SHR and SORTHEAP)

Total sorts                                = 0
Total sort time (ms)                       = 0
Sort overflows                        = 0              (SORTHEAP)
Active sorts                               = 0

Buffer pool data logical reads             = 370
Buffer pool data physical reads            = 54
Buffer pool temporary data logical reads   = 0
Buffer pool temporary data physical reads  = 0
Asynchronous pool data page reads     = 9           (NUM_IOSERVERS)
Buffer pool data writes               = 3      (CHNGPGS_THRESH and NUM_IOCLEANERS)
Asynchronous pool data page writes    = 0      (CHNGPGS_THRESH and NUM_IOCLEANERS)


Buffer pool index logical reads            = 221
Buffer pool index physical reads           = 94
Buffer pool temporary index logical reads  = 0
Buffer pool temporary index physical reads = 0
Asynchronous pool index page reads    = 0         (NUM_IOSERVERS)
Buffer pool index writes              = 0      (CHNGPGS_THRESH and NUM_IOCLEANERS)
Asynchronous pool index page writes   = 0     (CHNGPGS_THRESH and NUM_IOCLEANERS)

Total buffer pool read time (ms)           = 287
Total buffer pool write time (ms)          = 1
Total elapsed asynchronous read time       = 0
Total elapsed asynchronous write time      = 0
Asynchronous data read requests            = 3
Asynchronous index read requests           = 0
No victim buffers available                = 0
LSN Gap cleaner triggers                   = 0
Dirty page steal cleaner triggers     = 0            (CHNGPGS_THRESH)
Dirty page threshold cleaner triggers = 0           (CHNGPGS_THRESH)
Time waited for prefetch (ms)         = 0            (NUM_IOSERVERS)

Unread prefetch pages                      = 0
Direct reads                               = 86
Direct writes                              = 4
Direct read requests                       = 14
Direct write requests                      = 2
Direct reads elapsed time (ms)             = 247
Direct write elapsed time (ms)             = 56
Database files closed                 = 0          (MAXFILOP)
Data pages copied to extended storage      = 0
Index pages copied to extended storage     = 0
Data pages copied from extended storage    = 0
Index pages copied from extended storage   = 0

Host execution elapsed time                = 0.000039

Commit statements attempted                = 6
Rollback statements attempted              = 1
Dynamic statements attempted               = 281
Static statements attempted                = 7
Failed statement operations                = 1
Select SQL statements executed             = 4
Update/Insert/Delete statements executed   = 0
DDL statements executed                    = 2

Internal automatic rebinds                 = 0
Internal rows deleted                      = 0
Internal rows inserted                     = 0
Internal rows updated                      = 0
Internal commits                           = 1
Internal rollbacks                         = 0
Internal rollbacks due to deadlock         = 0

Rows deleted                               = 0
Rows inserted                              = 0
Rows updated                               = 0
Rows selected                              = 336
Rows read                                  = 375
Binds/precompiles attempted                = 0

Log space available to the database (Bytes)= 5095757   (LOGPRIMARY and LOGSECOND)
Log space used by the database (Bytes)     = 4243
Maximum secondary log space used (Bytes)   = 0
Maximum total log space used (Bytes)  = 6498    (LOGPRIMARY and LOGSECOND)
Secondary logs allocated currently    = 0      (LOGPRIMARY and LOGSECOND)
Log pages read                        = 0              (LOGBUFSZ)
Log pages written                     = 5              (LOGBUFSZ)

Appl id holding the oldest transaction     = 38

Package cache lookups                 = 10        (PKGCACHESZ)
Package cache inserts                 = 8         (PKGCACHESZ)
Package cache overflows               = 0         (PKGCACHESZ)
Package cache high water mark (Bytes) = 191140    (PKGCACHESZ)

Application section lookups                = 281
Application section inserts                = 6

Catalog cache lookups                 = 18       (CATALOGCACHE_SZ)
Catalog cache inserts                 = 9        (CATALOGCACHE_SZ)
Catalog cache overflows               = 0        (CATALOGCACHE_SZ)
Catalog cache high water mark         = 0        (CATALOGCACHE_SZ)


Workspace Information

 Shared high water mark                    = 0
 Corresponding shared overflows            = 0
 Total shared section inserts              = 0
 Total shared section lookups              = 0
 Private high water mark                   = 21102
 Corresponding private overflows           = 0
 Total private section inserts             = 6
 Total private section lookups             = 6

Number of hash joins                       = 0
Number of hash loops                       = 0
Number of hash join overflows         = 0         (SORTHEAP)
Number of small hash join overflows   = 0         (SORTHEAP)