Sample DBInfo Report
Following is a sample DBInfo Report for a database called BANKDB. The report lists information about your mainframe, which is followed by information from the DESCRIPTION file, the DMSUPPORT file, and the CONTROL file (in that order). Each item listed under a file is explained in Unisys DMSII documentation.
The second half of the report displays DATABridge product license keys, the DBEngine run-time parameters that are in effect for the specified database, and a list of the DATABridge programs (including versions and compile times) installed on your mainframe.
DATABridge Database Info Version 62.000.0000 compiled Thursday, September 13, 2012 @ 13:34:51 DATABridge DBInfo Report generated Tuesday, October 16, 2012 @ 19:42:09 CS400:1122 GALILEO SSR 55.189.8085, Microcode 9.154 Friday, July 9, 2010 (GPC)DESCRIPTION/BANKDB ON USER ------------------------------- Desc. timestamp Wednesday, September 12, 2012 @ 08:57:54 DASDL release 55.189 Property level 050510 DB name BANKDB DB timestamp Wednesday, September 12, 2012 @ 08:57:54 Update level 1 Update timestamp Wednesday, September 12, 2012 @ 08:57:55 DMSII release 55.189 DB prop. level 050510 ACCESSROUTINES SYSTEM/ACCESSROUTINES RECOVERY SYSTEM/DMRECOVERY DATARECOVERY SYSTEM/DMDATARECOVERY RECONSTRUCT RECONSTRUCT/BANKDB GUARDFILE <none> Reorg required False INDEPENDENTTRANS True REAPPLYCOMPLETED True Backout to SYNC False RDSSTORE False Statistics False Is a MODEL False (DB62)DMSUPPORT/BANKDB ON USER ------------------------------ DB name BANKDB DB timestamp Wednesday, September 12, 2012 @ 08:57:54 Update level 1 Update timestamp Wednesday, September 12, 2012 @ 08:57:55 INDEPENDENTTRANS True REAPPLYCOMPLETED True Last structure 56 Phys. structures 41 (GPC)BANKDB/CONTROL ON DB. -------------------------- CF format level 3900 CF release 55.189.8000 CF creation Wednesday, September 12, 2012 @ 08:58:01 DB timestamp Wednesday, September 12, 2012 @ 08:57:54 Update level 1 Update timestamp Wednesday, September 12, 2012 @ 08:57:55 Reorg state 0 INDEPENDENTTRANS True REAPPLYCOMPLETED True INUSE False REBUILD False ROLLBACK False RECONSTRUCT False TRACKER False FAMILY change False Audit file nbr. 1 Audit block nbr. 130 Product License expiration Parameter file --------------------------------------- ------------------- -------------------- MCP DATABridge perpetual (DB62)DATA/ENGINE/CONTROL ON USER MCP FileXtract perpetual (DB62)DATA/ENGINE/CONTROL ON USER MCP Twin perpetual (DB62)DATA/ENGINE/CONTROL ON USER MCP DMSII Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER MCP Plus perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows Oracle Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER AIX Oracle Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER HP-UX Oracle Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER SunOS Oracle Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER Linux Oracle Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER HP-UX Informix Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER AIX DB2 Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows DB2 Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows MS-SQL Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows ODBC Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows DBEnterprise perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows Sybase Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER SunOS Sybase Client perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows AuditMirror perpetual (DB62)DATA/ENGINE/CONTROL ON USER Windows File Transfer perpetual (DB62)DATA/ENGINE/CONTROL ON USER Parameters ---------- Extract Workers default: 4 (allow 1 - 10) Enterprise Workers default: 20 (max100) Checkpoint Records default: 1000 (allow 1 - 9999999) Checkpoint Blocks default: 100 (allow any) Checkpoint Transactions default: 0 (allow any) Checkpoint Minutes default: 0 (allow any) Checkpoint Long Trans = false Remote host readahead = true Print statistics = false Include link items = false Allow DBPlus = true Access active audit = true Convert reversals = false Mirrored database = false Mirrored audit = false Product key = XXXXXXXXXXXXXXXXXXXXXXXX Evaluation key = <none> DMAlgol = *SYSTEM/DMALGOL ON DISK DMUtility = *SYSTEM/DMUTILITY ON DISK DMControl = *SYSTEM/DMCONTROL ON DISK DMRecovery = *SYSTEM/DMRECOVERY ON DISK Database available anytime Version Program Compile Timestamp ----------------------- -------------------------------------------------------------------------- ------------------------------ 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SPAN ON USER Thursday, September 13, 2012 @ 13:34:02 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/TWIN ON USER Thursday, September 13, 2012 @ 13:34:07 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/DBINFO ON USER Thursday, September 13, 2012 @ 13:34:49 62.000.0011 SSR 55.170 (DB62)OBJECT/DATABRIDGE/ENGINE ON USER Monday, October 15, 2012 @ 13:10:32 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/LISTER ON USER Thursday, September 13, 2012 @ 13:34:33 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/SQLGEN ON USER Thursday, September 13, 2012 @ 13:36:00 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/ENCRYPT ON USER Thursday, September 13, 2012 @ 13:36:03 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/READDOC ON USER Thursday, September 13, 2012 @ 13:36:12 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/COBOLGEN ON USER Thursday, September 13, 2012 @ 13:36:02 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/DASDLGEN ON USER Thursday, September 13, 2012 @ 13:36:06 00.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/MINISPAN ON USER Thursday, September 13, 2012 @ 13:36:07 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/REFORMAT ON USER Thursday, September 13, 2012 @ 13:34:57 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/AUDITCLOSE ON USER Thursday, September 13, 2012 @ 13:36:05 00.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/MINILISTER ON USER Thursday, September 13, 2012 @ 13:36:09 00.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/COBOLFORMAT ON USER Thursday, September 13, 2012 @ 13:36:13 00.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SAMPLE/EXTRACTADDRESS ON USER Thursday, September 13, 2012 @ 13:34:58 62.000.0001 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SERVER ON USER Thursday, September 13, 2012 @ 13:34:38 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/TANKER ON USER Thursday, September 13, 2012 @ 13:34:35 62.000.0003 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SUPPORT ON USER Monday, October 15, 2012 @ 08:45:34 62.000.0002 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SUPPORT/TEST3DB ON USER Monday, August 27, 2012 @ 18:31:29 62.000.0002 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SUPPORT/TEST3DB/1 ON USER Monday, August 27, 2012 @ 18:31:29 62.000.0003 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SUPPORT/NZTESTDB/COMPARE ON USER Monday, October 15, 2012 @ 13:15:18 62.000.0002 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SUPPORT/USERDATADB/1 ON USER Tuesday, August 28, 2012 @ 13:56:24 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/SNAPSHOT ON USER Thursday, September 13, 2012 @ 13:34:52 62.000.0001 SSR 55.170 (DB62)OBJECT/DATABRIDGE/GENFORMAT ON USER Friday, September 28, 2012 @ 15:01:35 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/AUDITTIMER ON USER Thursday, September 13, 2012 @ 13:34:17 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/CHANGEUSER ON USER Thursday, September 13, 2012 @ 13:34:47 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/AUDITMIRROR ON USER Thursday, September 13, 2012 @ 13:34:19 62.000.0001 SSR 55.170 (DB62)OBJECT/DATABRIDGE/DMSIICLIENT ON USER Thursday, September 13, 2012 @ 13:34:10 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/DMSIICLIENT/LIB/CLIENTDB ON USER Wednesday, September 12, 2012 @ 09:10:04 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/DMSIICLIENT/AUTOCONNECT ON USER Thursday, September 13, 2012 @ 13:34:17 62.000.0000 SSR 55.170 (DB62)OBJECT/DATABRIDGE/COBOLSUPPORT ON USER Thursday, September 13, 2012 @ 13:34:55 End of DBInfo report |
 |