[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:	DEC Rdb against the World

Moderator:	HERON::GODFRIND

Created:	Fri Jun 12 1987
Last Modified:	Thu Feb 23 1995
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1348
Total number of notes:	5438

1120.0. "MACPAC and Rdb Performance" by 17185::GOLFNG::DONOVAN (Patti Donovan, 445-6390) Tue Mar 24 1992 23:09

    I have a customer who is using MACPAC/D and is complaining about the
    performance of Rdb.  They only have a small amount of data at this
    time.  All of the Rdb database files reside on the same disk as do all of
    the DBMS files.  

    They said that when 10 users all try to update the same table it takes 
    10-20 seconds.  

    I did notice that the problem table has two indexes, one of which
    consists of 16 fields out of the 20 columns in the table!  They said
    that is because they may need to search on any of the 16 fields.  I
    explained how they should format an index if this is how they wanted to
    do their searches as well as recommended RdbExpert and DECtrace.  I am
    wondering if it is really an application problem.

    I talked to Pete Eggimann who is an Application Partner Engineer and he
    said that most of the tuning has been with the DBMS modules.  

    I am concerned about this customer's perception of Rdb.  The system
    manager is very pro-Oracle and is planning on going to the upcoming
    user's group.   

    Are any other customers complaining about Rdb with respect to MACPAC/D?

    Patti

    Cross-posted in Rdb_VMS_Competition

T.R	Title	User	Personal Name	Date	Lines
1120.1		CSSEDB::MOY	Michael G. Moy, Rdb/VMS Engineering	`Wed Mar 25 1992 04:37`	13
	It would be hard to tell what the problem is given the description but here are a few things to consider or look into: 1) Use RMU/SHOW STAT to see if there is a contention problem. 2) Use MON CLUS to see if the CPU or disk is the bottleneck. 3) Set RDMS$DEBUG_FLAGS to "S" to see if the optimizer is producing a poor strategy (highly unlikely if this is a small table). They might also consider asking Colorado to dial into the system to do the above along with any other performance analysis (this is probably more a consulting issue than a remedial one though). michael moy
1120.2	My guess is some locking problem someplace...	COOKIE::OAKEY	The Last Bugcheck - The Sequel	`Wed Mar 25 1992 16:02`	19
	� <<< Note 1120.1 by CSSEDB::MOY "Michael G. Moy, Rdb/VMS Engineering" >>> A few other thoughts... You don't have to have an index in order to use the column for retrieval. In addition, depending on the version of Rdb, if the only column that you're referencing is the 16th column in the multi-column (multi-segment) index, the index probably won't be used anyway. A possibly better bet would be 16 separate indexes and not 1 index with 16 segments... (if they've got Rdb V4.0 then the dynamic optimizer can (depending on the query) make efficient use of multiple indexes used in the query). In RMU/SHOW STAT check the stall messages and see if user's are stalling and what resource they are stalling for... With the Debug Flag set to "S" see if the index is even being used (or which index is being used). If sequential retrieval is being used, this produces table-level locking which may be less than desirable.
1120.3		STOHUB::GOLFNG::DONOVAN	Patti Donovan, 445-6390	`Sat Mar 28 1992 00:49`	41
	> My guess is some locking problem someplace... That was my first thought. Users are using the system for training only, so 10 people access the DBMS database and then all the users access the Rdb online transaction history table. > You don't have to have an index in order to use the column for retrieval. > In addition, depending on the version of Rdb, if the only column that > you're referencing is the 16th column in the multi-column (multi-segment) > index, the index probably won't be used anyway. A possibly better bet > would be 16 separate indexes and not 1 index with 16 segments... (if > they've got Rdb V4.0 then the dynamic optimizer can (depending on the > query) make efficient use of multiple indexes used in the query). I agree with this line of thought exactly. I had asked the customer to remove this index and do a before and after test, but they wanted to back up the database first. > With the Debug Flag set to "S" see if the index is even being used (or > which index is being used). If sequential retrieval is being used, this > produces table-level locking which may be less than desirable. In this instance the customer was updating. We had a slight problem with the RDMS$DEBUG_FLAGS because I didn't know that the user process was not accessing the database. > In RMU/SHOW STAT check the stall messages and see if user's are stalling > and what resource they are stalling for... The customer is sending me the several files including RMU/SHOW STATISTICS and RMU/ANALYZE which I will post when I receive them. I have asked them to test again after removing the index in question. The have also increased the buffer size to 32 pages which I asked them to reduce in another test. Unfortunately, I think the problem with this is application is the lack of good design and use of CASE technology. Our goal is to get the customer over this hump and eventually sell them RdbExpert and DECtrace.
1120.4	File I/O Statistics	STOHUB::GOLFNG::DONOVAN	Patti Donovan, 445-6390	`Mon Mar 30 1992 18:36`	97
	Node: MRPPRO Rdb/VMS V4.0-0 Performance Monitor 20-MAR-1992 09:08:49 File IO Statistics For Database: $1$DUA29:[MACPAC.V614.RDB]MACPAC_PR_ROOT.RDB;1 -------------------------------------------------------------------------------- For File: $1$DUA29:[MACPAC.V614.RDB]OTH_INDICES.RDA;1 statistic......... rate.per.second......... total... average.. name.............. max. cur. avg... count... per.trans total I/Os 0 1097 4.2 (reads) 4 0 0.6 659 2.5 (writes) 3 0 0.4 438 1.7 (extends) 0 0 0.0 0 0.0 statistic......... blocks.transferred.... stall.time.(x100)...... name.............. avg.per.I/O total... avg.per.I/O total... total I/Os 35.6 39066 7.7 8416 (reads) 57.8 38084 5.2 3436 (writes) 2.2 982 11.4 4980 (extends) 0.00 0.0 0 -------------------------------------------------------------------------------- Display_menu Exit Help Options Reset Set_rate Write_screen Node: MRPPRO Rdb/VMS V4.0-0 Performance Monitor 20-MAR-1992 09:08:49 File IO Statistics For Database: $1$DUA29:[MACPAC.V614.RDB]MACPAC_PR_ROOT.RDB;1 -------------------------------------------------------------------------------- For File: $1$DUA29:[MACPAC.V614.RDB]OTH_VDA.RDA;1 statistic......... rate.per.second......... total... average.. name.............. max. cur. avg... count... per.trans total I/Os 0 190 0.7 (reads) 1 0 0.1 138 0.5 (writes) 1 0 0.0 52 0.2 (extends) 0 0 0.0 0 0.0 statistic......... blocks.transferred.... stall.time.(x100)...... name.............. avg.per.I/O total... avg.per.I/O total... total I/Os 34.1 6482 7.2 1369 (reads) 44.3 6118 3.4 466 (writes) 7.0 364 17.4 903 (extends) 0.00 0.0 0 -------------------------------------------------------------------------------- Display_menu Exit Help Options Reset Set_rate Write_screen Node: MRPPRO Rdb/VMS V4.0-0 Performance Monitor 20-MAR-1992 09:08:49 File IO Statistics For Database: $1$DUA29:[MACPAC.V614.RDB]MACPAC_PR_ROOT.RDB;1 -------------------------------------------------------------------------------- For File: $1$DUA29:[MACPAC.V614.RDB]OTH_FM.RDA;1 statistic......... rate.per.second......... total... average.. name.............. max. cur. avg... count... per.trans total I/Os 0 372 1.4 (reads) 1 0 0.2 262 1.0 (writes) 1 0 0.1 110 0.4 (extends) 0 0 0.0 0 0.0 statistic......... blocks.transferred.... stall.time.(x100)...... name.............. avg.per.I/O total... avg.per.I/O total... total I/Os 34.6 12888 5.4 2006 (reads) 45.2 11840 5.5 1437 (writes) 9.5 1048 5.2 569 (extends) 0.00 0.0 0 -------------------------------------------------------------------------------- Display_menu Exit Help Options Reset Set_rate Write_screen Node: MRPPRO Rdb/VMS V4.0-0 Performance Monitor 20-MAR-1992 09:08:49 File IO Statistics For Database: $1$DUA29:[MACPAC.V614.RDB]MACPAC_PR_ROOT.RDB;1 -------------------------------------------------------------------------------- For File: $1$DUA29:[MACPAC.V614.RDB]OTH_PRT.RDA;1 statistic......... rate.per.second......... total... average.. name.............. max. cur. avg... count... per.trans total I/Os 0 0 0.0 (reads) 0 0 0.0 0 0.0 (writes) 0 0 0.0 0 0.0 (extends) 0 0 0.0 0 0.0 statistic......... blocks.transferred.... stall.time.(x100)...... name.............. avg.per.I/O total... avg.per.I/O total... total I/Os 0.00 0.0 0 (reads) 0.00 0.0 0 (writes) 0.00 0.0 0 (extends) 0.00 0.0 0 -------------------------------------------------------------------------------- Display_menu Exit Help Options Reset Set_rate Write_screen
1120.5	Dump of DB Header	STOHUB::GOLFNG::DONOVAN	Patti Donovan, 445-6390	`Mon Mar 30 1992 18:38`	912
	------------------------------------------------------------------------------ Rdb/VMS V4.0-0 19-MAR-1992 11:42:19.24 * * Dump of Database header * Database: $1$DUA29:[MACPAC.V614.RDB]MACPAC_PR_ROOT.RDB;1 * *------------------------------------------------------------------------------ Database parameters Created at 13-MAR-1992 09:45:21.35 VAX RDMS structure level is 40.0 Maximum user count is 50 Maximum node count is 16 Buffer count is 256, each is 64 blocks long DBR buffer count is 100, each is 64 blocks long Adjustable record locking granularity factor count is 0 After image journaling is disabled - AIJ default allocation is 0 blocks - AIJ file extension is 512 blocks No default recovery unit journal filename Database is opened automatically on first user access Snapshots are non-deferred (normal) Security auditing parameters: - Security auditing is disabled - Security alarm is disabled - No audit journal filename is specified - No alarm name is specified - Synchronous audit record flushing is disabled - Audit every access Storage area RDB$SYSTEM Area ID number is 1 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]PRRDB.RDA;1 Page size is 2 blocks Initial data page count was 416 Current physical page count is 4994 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 2 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 29 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_BOM Area ID number is 2 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM.RDA;1 Page size is 5 blocks Initial data page count was 1008 Current physical page count is 1009 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 996 pages, maximum of 9996 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 6084 data pages Snapshots are allowed and disabled Snapshot area ID number is 30 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_CHG_DOC Area ID number is 3 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_CHG_DOC.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 31 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_CONF_ITEM Area ID number is 4 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_CONF_ITEM.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 32 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_DW Area ID number is 5 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_DW.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 33 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_AB_EXCP Area ID number is 6 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_AB_EXCP.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 34 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_AD_EXCP Area ID number is 7 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_AD_EXCP.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 35 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_ALT_PART Area ID number is 8 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_ALT_PART.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 36 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_BOM_INDX1 Area ID number is 9 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX1.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 37 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_BOM_INDX2 Area ID number is 10 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX2.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 38 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_BOM_INDX3 Area ID number is 11 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX3.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 39 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area AB_BOM_INDX4 Area ID number is 12 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX4.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 40 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_INSPEC Area ID number is 13 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_INSPEC.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 41 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_NONCON Area ID number is 14 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_NONCON.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 42 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_SQUAWK Area ID number is 15 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_SQUAWK.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 43 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_EFFECT Area ID number is 16 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_EFFECT.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 44 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_CAAGE Area ID number is 17 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_CAAGE.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 45 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_SERNBR Area ID number is 18 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_SERNBR.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 46 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_NONAGE Area ID number is 19 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_NONAGE.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 47 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_PDDISP Area ID number is 20 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_PDDISP.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 48 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area QA_INDICES Area ID number is 21 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]QA_INDICES.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 49 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area OTH_FM Area ID number is 22 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_FM.RDA;1 Page size is 8 blocks Initial data page count was 2000 Current physical page count is 2001 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 496 pages, maximum of 9992 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 8136 data pages Snapshots are allowed and disabled Snapshot area ID number is 50 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area OTH_VDA Area ID number is 23 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_VDA.RDA;1 Page size is 7 blocks Initial data page count was 2007 Current physical page count is 2008 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 495 pages, maximum of 9999 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 7533 data pages Snapshots are allowed and disabled Snapshot area ID number is 51 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area OTH_PRT Area ID number is 24 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_PRT.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 52 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area OTH_INDICES Area ID number is 25 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_INDICES.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 53 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area MS_BAS Area ID number is 26 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]MS_BAS.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 54 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area MS_DET Area ID number is 27 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]MS_DET.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 55 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Storage area MS_INDICES Area ID number is 28 Storage area page format is uniform Filename is $1$DUA29:[MACPAC.V614.RDB]MS_INDICES.RDA;1 Page size is 2 blocks Initial data page count was 1024 Current physical page count is 1025 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 480 pages, maximum of 9984 pages - Volume set spreading is enabled Area has space management pages - Current SPAM page count is 1 - Interval is 3168 data pages Snapshots are allowed and disabled Snapshot area ID number is 56 Area last backed up at 19-MAR-1992 11:33:24.52 Area has never been incrementally restored Snapshot area for storage area RDB$SYSTEM Area ID number is 29 Storage area DBID on pages is 16385 Filename is $1$DUA29:[MACPAC.V614.RDB]PRRDB.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 1442 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_BOM Area ID number is 30 Storage area DBID on pages is 16386 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM.SNP;1 Page size is 5 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9996 pages - Volume set spreading is enabled Snapshot area for storage area AB_CHG_DOC Area ID number is 31 Storage area DBID on pages is 16387 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_CHG_DOC.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_CONF_ITEM Area ID number is 32 Storage area DBID on pages is 16388 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_CONF_ITEM.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_DW Area ID number is 33 Storage area DBID on pages is 16389 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_DW.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_AB_EXCP Area ID number is 34 Storage area DBID on pages is 16390 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_AB_EXCP.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_AD_EXCP Area ID number is 35 Storage area DBID on pages is 16391 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_AD_EXCP.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_ALT_PART Area ID number is 36 Storage area DBID on pages is 16392 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_ALT_PART.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_BOM_INDX1 Area ID number is 37 Storage area DBID on pages is 16393 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX1.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_BOM_INDX2 Area ID number is 38 Storage area DBID on pages is 16394 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX2.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_BOM_INDX3 Area ID number is 39 Storage area DBID on pages is 16395 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX3.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area AB_BOM_INDX4 Area ID number is 40 Storage area DBID on pages is 16396 Filename is $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX4.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_INSPEC Area ID number is 41 Storage area DBID on pages is 16397 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_INSPEC.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_NONCON Area ID number is 42 Storage area DBID on pages is 16398 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_NONCON.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_SQUAWK Area ID number is 43 Storage area DBID on pages is 16399 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_SQUAWK.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_EFFECT Area ID number is 44 Storage area DBID on pages is 16400 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_EFFECT.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_CAAGE Area ID number is 45 Storage area DBID on pages is 16401 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_CAAGE.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_SERNBR Area ID number is 46 Storage area DBID on pages is 16402 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_SERNBR.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_NONAGE Area ID number is 47 Storage area DBID on pages is 16403 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_NONAGE.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_PDDISP Area ID number is 48 Storage area DBID on pages is 16404 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_PDDISP.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area QA_INDICES Area ID number is 49 Storage area DBID on pages is 16405 Filename is $1$DUA29:[MACPAC.V614.RDB]QA_INDICES.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area OTH_FM Area ID number is 50 Storage area DBID on pages is 16406 Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_FM.SNP;1 Page size is 8 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9992 pages - Volume set spreading is enabled Snapshot area for storage area OTH_VDA Area ID number is 51 Storage area DBID on pages is 16407 Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_VDA.SNP;1 Page size is 7 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 99 pages, maximum of 9999 pages - Volume set spreading is enabled Snapshot area for storage area OTH_PRT Area ID number is 52 Storage area DBID on pages is 16408 Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_PRT.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area OTH_INDICES Area ID number is 53 Storage area DBID on pages is 16409 Filename is $1$DUA29:[MACPAC.V614.RDB]OTH_INDICES.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area MS_BAS Area ID number is 54 Storage area DBID on pages is 16410 Filename is $1$DUA29:[MACPAC.V614.RDB]MS_BAS.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area MS_DET Area ID number is 55 Storage area DBID on pages is 16411 Filename is $1$DUA29:[MACPAC.V614.RDB]MS_DET.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled Snapshot area for storage area MS_INDICES Area ID number is 56 Storage area DBID on pages is 16412 Filename is $1$DUA29:[MACPAC.V614.RDB]MS_INDICES.SNP;1 Page size is 2 blocks Initial data page count was 100 Current physical page count is 100 Extends are enabled - Area has never been extended - Extend area by 20%, minimum of 96 pages, maximum of 9984 pages - Volume set spreading is enabled No active users Rdb/VMS specific root record DBKEY for Rdb/VMS bootstrap page is 8:2274:0 Release retrieval locks when no longer needed Do not wait on record lock conflicts Latest full backup file is dated 19-MAR-1992 11:33:24.52 Latest full backup transaction sequence number is 1668 Database has never been incrementally restored Latest full restore occurred at 18-MAR-1992 15:44:10.29 Database has never been verified Database has never been altered
1120.6	How did they save the SHOW STATS?	COOKIE::OAKEY	The Last Bugcheck - The Sequel	`Mon Mar 30 1992 18:39`	8
	� <<< Note 1120.3 by STOHUB::GOLFNG::DONOVAN "Patti Donovan, 445-6390" >>> � The customer is sending me the several files including RMU/SHOW � STATISTICS and RMU/ANALYZE which I will post when I receive them. Just be aware of how the customer collected the statistical data... The stall messages from SHOW STATs isn't recorded in the binary file for playback. They'll have to capture the screen to see stall info.
1120.7	No summary yet	STOHUB::GOLFNG::DONOVAN	Patti Donovan, 445-6390	`Mon Mar 30 1992 18:43`	7
	> Just be aware of how the customer collected the statistical data... The > stall messages from SHOW STATs isn't recorded in the binary file for > playback. They'll have to capture the screen to see stall info. Thanks for the hint. Unfortunately, the customer has not sent me the summary screen. I've included what I have received so far and can ask for other reports if necessary.
1120.8	Indices for root file	STOHUB::GOLFNG::DONOVAN	Patti Donovan, 445-6390	`Mon Mar 30 1992 18:44`	259
	------------------------------------------------------------------------------ Indices for database - $1$DUA29:[MACPAC.V614.RDB]MACPAC_PR_ROOT.RDB; ------------------------------------------------------------------------------ Index ABB_INDX1 for relation TBL_AB_BOM duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index ABB_INDX2 for relation TBL_AB_BOM duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index ABB_INDX3 for relation TBL_AB_BOM duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index ABB_INDX4 for relation TBL_AB_BOM duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index BASINDX for relation TBL_MS_BAS duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index CHD_INDX1 for relation TBL_AB_CHG_DOC duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index CHD_INDX2 for relation TBL_AB_CHG_DOC duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index CIS_INDX1 for relation TBL_AB_CONF_ITEM duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index CIS_INDX2 for relation TBL_AB_CONF_ITEM duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index DETINDX for relation TBL_MS_DET duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index DWD_INDX1 for relation TBL_AB_DW_DTL duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index DWD_INDX2 for relation TBL_AB_DW_DTL duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index DWH_INDX1 for relation TBL_AB_DW_HDR duplicates allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index EFFECT_INDEX for relation TBL_QA_EFFECT duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index FM_INDEX for relation TBL_OTH_FM duplicates not allowed Max Level: 3, Nodes: 57, Used/Avail: 19980/22686 (88%), Keys: 1247, Records: 1191 ------------------------------------------------------------------------------ Index FM_INDEX2 for relation TBL_OTH_FM duplicates allowed Max Level: 3, Nodes: 136, Used/Avail: 75170/112608 (67%), Keys: 798, Records: 311 Duplicate nodes: 353, Used/Avail: 7040/28988 (24%), Keys: 352, Records: 880 ------------------------------------------------------------------------------ Index INSPEC_INDEX for relation TBL_QA_INSPEC duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index PRT_INDEX for relation TBL_OTH_PRT duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDB$CON_CONSTRAINT_NAME_X for relation RDB$CONSTRAINTS duplicates not allowed Max Level: 2, Nodes: 27, Used/Avail: 6821/10746 (63%), Keys: 399, Records: 373 ------------------------------------------------------------------------------ Index RDB$CR_CONSTRAINT_NAME_NDX for relation RDB$CONSTRAINT_RELATIONS duplicates allowed Max Level: 2, Nodes: 27, Used/Avail: 6821/10746 (63%), Keys: 399, Records: 373 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDB$CR_REL_NAME_NDX for relation RDB$CONSTRAINT_RELATIONS duplicates allowed Max Level: 2, Nodes: 4, Used/Avail: 688/1592 (43%), Keys: 24, Records: 0 Duplicate nodes: 34, Used/Avail: 2984/6854 (44%), Keys: 21, Records: 373 ------------------------------------------------------------------------------ Index RDB$FIELDS_NAME_NDX for relation RDB$FIELDS duplicates not allowed Max Level: 2, Nodes: 15, Used/Avail: 3625/5970 (61%), Keys: 135, Records: 121 ------------------------------------------------------------------------------ Index RDB$NDX_NDX_NAME_NDX for relation RDB$INDICES duplicates not allowed Max Level: 2, Nodes: 8, Used/Avail: 1780/3184 (56%), Keys: 62, Records: 55 ------------------------------------------------------------------------------ Index RDB$NDX_REL_NAME_NDX for relation RDB$INDICES duplicates allowed Max Level: 2, Nodes: 5, Used/Avail: 1106/1990 (56%), Keys: 39, Records: 19 Duplicate nodes: 16, Used/Avail: 288/752 (38%), Keys: 16, Records: 36 ------------------------------------------------------------------------------ Index RDB$NDX_SEG_NAM_FLD_POS_NDX for relation RDB$INDEX_SEGMENTS duplicates not allowed Max Level: 2, Nodes: 11, Used/Avail: 2542/4378 (58%), Keys: 132, Records: 122 ------------------------------------------------------------------------------ Index RDB$REL_REL_ID_NDX for relation RDB$RELATIONS duplicates not allowed Max Level: 1, Nodes: 1, Used/Avail: 240/398 (60%), Keys: 39, Records: 39 ------------------------------------------------------------------------------ Index RDB$REL_REL_NAME_NDX for relation RDB$RELATIONS duplicates not allowed Max Level: 2, Nodes: 6, Used/Avail: 1209/2388 (51%), Keys: 44, Records: 39 ------------------------------------------------------------------------------ Index RDB$RFR_REL_FLD_NAMES_NDX for relation RDB$RELATION_FIELDS duplicates allowed Max Level: 2, Nodes: 6, Used/Avail: 1277/2388 (53%), Keys: 44, Records: 0 Duplicate nodes: 52, Used/Avail: 4488/9308 (48%), Keys: 39, Records: 561 ------------------------------------------------------------------------------ Index RDB$VER_REL_ID_VER_NDX for relation RDB$FIELD_VERSIONS duplicates allowed Max Level: 1, Nodes: 1, Used/Avail: 314/398 (79%), Keys: 39, Records: 0 Duplicate nodes: 52, Used/Avail: 4488/9308 (48%), Keys: 39, Records: 561 ------------------------------------------------------------------------------ Index RDB$VIEW_REL_NAME_NDX for relation RDB$VIEW_RELATIONS duplicates allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDB$VIEW_VIEW_NAME_NDX for relation RDB$VIEW_RELATIONS duplicates allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$COLLATIONS_NDX for relation RDBVMS$COLLATIONS duplicates not allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$INTER_CON_NAM_NDX for relation RDBVMS$INTERRELATIONS duplicates allowed Max Level: 2, Nodes: 28, Used/Avail: 6902/11144 (62%), Keys: 401, Records: 373 Duplicate nodes: 17, Used/Avail: 5968/6448 (93%), Keys: 1, Records: 746 ------------------------------------------------------------------------------ Index RDBVMS$INTER_ENTITY_NDX for relation RDBVMS$INTERRELATIONS duplicates allowed Max Level: 3, Nodes: 91, Used/Avail: 22296/36218 (62%), Keys: 484, Records: 0 Duplicate nodes: 407, Used/Avail: 8952/36694 (24%), Keys: 394, Records: 1119 ------------------------------------------------------------------------------ Index RDBVMS$INTER_REL_FLD_NDX for relation RDBVMS$INTERRELATIONS duplicates allowed Max Level: 3, Nodes: 63, Used/Avail: 16161/25074 (64%), Keys: 457, Records: 373 Duplicate nodes: 43, Used/Avail: 5968/10118 (59%), Keys: 22, Records: 746 ------------------------------------------------------------------------------ Index RDBVMS$PRV_FLD_ID_NDX for relation RDBVMS$PRIVILEGES duplicates allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$PRV_REL_ID_NDX for relation RDBVMS$PRIVILEGES duplicates allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$RCF_CONSTRAINT_NAME_NDX for relation RDBVMS$RELATION_CONSTRAINT_FLDS duplicates allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$RLC_CONSTRAINT_NAME_NDX for relation RDBVMS$RELATION_CONSTRAINTS duplicates not allowed Max Level: 2, Nodes: 27, Used/Avail: 6821/10746 (63%), Keys: 399, Records: 373 ------------------------------------------------------------------------------ Index RDBVMS$RLC_FIELD_NAME_NDX for relation RDBVMS$RELATION_CONSTRAINTS duplicates allowed Max Level: 3, Nodes: 48, Used/Avail: 12067/19104 (63%), Keys: 420, Records: 373 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$RLC_RELATION_NAME_NDX for relation RDBVMS$RELATION_CONSTRAINTS duplicates allowed Max Level: 2, Nodes: 4, Used/Avail: 698/1592 (44%), Keys: 24, Records: 0 Duplicate nodes: 34, Used/Avail: 2984/6854 (44%), Keys: 21, Records: 373 ------------------------------------------------------------------------------ Index RDBVMS$STO_MAP_AREA_AREA_NDX for relation RDBVMS$STORAGE_MAP_AREAS duplicates allowed Max Level: 2, Nodes: 4, Used/Avail: 937/1592 (59%), Keys: 30, Records: 21 Duplicate nodes: 6, Used/Avail: 208/480 (43%), Keys: 6, Records: 26 ------------------------------------------------------------------------------ Index RDBVMS$STO_MAP_AREA_MAP_NDX for relation RDBVMS$STORAGE_MAP_AREAS duplicates allowed Max Level: 2, Nodes: 7, Used/Avail: 1678/2786 (60%), Keys: 53, Records: 47 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$STO_MAP_MAP_NAM_NDX for relation RDBVMS$STORAGE_MAPS duplicates allowed Max Level: 2, Nodes: 7, Used/Avail: 1678/2786 (60%), Keys: 53, Records: 47 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$STO_MAP_REL_NAM_NDX for relation RDBVMS$STORAGE_MAPS duplicates allowed Max Level: 2, Nodes: 4, Used/Avail: 719/1592 (45%), Keys: 25, Records: 21 Duplicate nodes: 2, Used/Avail: 208/478 (44%), Keys: 1, Records: 26 ------------------------------------------------------------------------------ Index RDBVMS$TRG_RELATION_NAME_NDX for relation RDBVMS$TRIGGERS duplicates allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 Duplicate nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index RDBVMS$TRG_TRIGGER_NAME_NDX for relation RDBVMS$TRIGGERS duplicates not allowed Max Level: 1, Nodes: 1, Used/Avail: 0/398 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index TAC_INDEX for relation TBL_QA_CAAGE duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index TAN_INDEX for relation TBL_QA_NONAGE duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index TNC_INDEX for relation TBL_QA_NONCON duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index TPD_INDEX for relation TBL_QA_PDDISP duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index TSN_INDEX for relation TBL_QA_SERNBR duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index TSQ_INDEX for relation TBL_QA_SQUAWK duplicates not allowed Max Level: 0, Nodes: 0, Used/Avail: 0/0 (0%), Keys: 0, Records: 0 ------------------------------------------------------------------------------ Index VDA_INDEX for relation TBL_OTH_VDA duplicates not allowed Max Level: 2, Nodes: 24, Used/Avail: 8638/9552 (90%), Keys: 534, Records: 511 ------------------------------------------------------------------------------ Index VDA_INDEX2 for relation TBL_OTH_VDA duplicates allowed Max Level: 3, Nodes: 81, Used/Avail: 44031/67068 (66%), Keys: 455, Records: 255 Duplicate nodes: 120, Used/Avail: 2048/9600 (21%), Keys: 120, Records: 256 ------------------------------------------------------------------------------
1120.9	Storage analysis of RDB$SYSTEM	STOHUB::GOLFNG::DONOVAN	Patti Donovan, 445-6390	`Mon Mar 30 1992 18:47`	873
	------------------------------------------------------------------------------ Storage analysis for storage area: RDB$SYSTEM - file: $1$DUA29:[MACPAC.V614.RDB]PRRDB.RDA;1 Area_id: 1, Page length: 1024, Last page: 4994 Bytes free: 2506146 (49%), bytes overhead: 1536118 (30%) Spam count: 2, AIP count: 32, ABM count: 1216 Data records: 6063, bytes used: 1071592 (21%) average length: 177, compression ratio: 1.00 index records: 1065, bytes used: 279240 (5%) B-Tree: 172056, Hash: 0, Duplicate: 107184, Overflow: 0 ------------------------------------ Logical area: RDB$SEGMENTED_STRINGS for storage area : RDB$SYSTEM Larea id: 1, Record type: 11, Record length: 984, Not Compressed Data records: 1206, bytes used: 44015 (1%) average length: 36 ------------------------------------ Logical area: RDB$RELATIONS for storage area : RDB$SYSTEM Larea id: 2, Record type: 4, Record length: 108, Not Compressed Data records: 39, bytes used: 4212 (0%) average length: 108 ------------------------------------ Logical area: RDB$FIELD_VERSIONS for storage area : RDB$SYSTEM Larea id: 3, Record type: 6, Record length: 132, Not Compressed Data records: 561, bytes used: 74613 (1%) average length: 133 ------------------------------------ Logical area: RDB$INDICES for storage area : RDB$SYSTEM Larea id: 4, Record type: 3, Record length: 102, Not Compressed Data records: 55, bytes used: 5610 (0%) average length: 102 ------------------------------------ Logical area: RDB$INDEX_SEGMENTS for storage area : RDB$SYSTEM Larea id: 5, Record type: 2, Record length: 80, Not Compressed Data records: 122, bytes used: 9638 (0%) average length: 79 ------------------------------------ Logical area: RDB$FIELDS for storage area : RDB$SYSTEM Larea id: 6, Record type: 1, Record length: 452, Not Compressed Data records: 121, bytes used: 54813 (1%) average length: 453 ------------------------------------ Logical area: RDB$RELATION_FIELDS for storage area : RDB$SYSTEM Larea id: 7, Record type: 5, Record length: 478, Not Compressed Data records: 561, bytes used: 268719 (5%) average length: 479 ------------------------------------ Logical area: RDB$DATABASE for storage area : RDB$SYSTEM Larea id: 8, Record type: 7, Record length: 634, Not Compressed Data records: 1, bytes used: 634 (0%) average length: 634 ------------------------------------ Logical area: RDB$VIEW_RELATIONS for storage area : RDB$SYSTEM Larea id: 9, Record type: 12, Record length: 68, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: RDB$CONSTRAINT_RELATIONS for storage area : RDB$SYSTEM Larea id: 10, Record type: 9, Record length: 70, Not Compressed Data records: 373, bytes used: 25737 (1%) average length: 69 ------------------------------------ Logical area: RDB$CONSTRAINTS for storage area : RDB$SYSTEM Larea id: 11, Record type: 8, Record length: 70, Not Compressed Data records: 373, bytes used: 25364 (0%) average length: 68 ------------------------------------ Logical area: RDB$NDX_SEG_NAM_FLD_POS_NDX for storage area : RDB$SYSTEM Larea id: 12, Record type: 0, Record length: 214, Not Compressed Data records: 11, bytes used: 4708 (0%) average length: 428 ------------------------------------ Logical area: RDB$NDX_NDX_NAME_NDX for storage area : RDB$SYSTEM Larea id: 13, Record type: 0, Record length: 214, Not Compressed Data records: 8, bytes used: 3424 (0%) average length: 428 ------------------------------------ Logical area: RDB$NDX_REL_NAME_NDX for storage area : RDB$SYSTEM Larea id: 14, Record type: 0, Record length: 4, Not Compressed Data records: 21, bytes used: 3372 (0%) average length: 161 ------------------------------------ Logical area: RDB$REL_REL_NAME_NDX for storage area : RDB$SYSTEM Larea id: 15, Record type: 0, Record length: 214, Not Compressed Data records: 7, bytes used: 2996 (0%) average length: 428 ------------------------------------ Logical area: RDB$VER_REL_ID_VER_NDX for storage area : RDB$SYSTEM Larea id: 16, Record type: 0, Record length: 214, Not Compressed Data records: 53, bytes used: 11296 (0%) average length: 213 ------------------------------------ Logical area: RDB$FIELDS_NAME_NDX for storage area : RDB$SYSTEM Larea id: 17, Record type: 0, Record length: 214, Not Compressed Data records: 15, bytes used: 6420 (0%) average length: 428 ------------------------------------ Logical area: RDB$RFR_REL_FLD_NAMES_NDX for storage area : RDB$SYSTEM Larea id: 18, Record type: 0, Record length: 214, Not Compressed Data records: 58, bytes used: 13436 (0%) average length: 232 ------------------------------------ Logical area: RDB$VIEW_VIEW_NAME_NDX for storage area : RDB$SYSTEM Larea id: 19, Record type: 0, Record length: 214, Not Compressed Data records: 2, bytes used: 856 (0%) average length: 428 ------------------------------------ Logical area: RDB$CON_CONSTRAINT_NAME_X for storage area : RDB$SYSTEM Larea id: 20, Record type: 0, Record length: 214, Not Compressed Data records: 27, bytes used: 11556 (0%) average length: 428 ------------------------------------ Logical area: RDB$CR_CONSTRAINT_NAME_NDX for storage area : RDB$SYSTEM Larea id: 21, Record type: 0, Record length: 214, Not Compressed Data records: 65, bytes used: 21142 (0%) average length: 325 ------------------------------------ Logical area: RDBVMS$STORAGE_MAPS for storage area : RDB$SYSTEM Larea id: 22, Record type: 13, Record length: 126, Not Compressed Data records: 47, bytes used: 5828 (0%) average length: 124 ------------------------------------ Logical area: RDBVMS$STORAGE_MAP_AREAS for storage area : RDB$SYSTEM Larea id: 23, Record type: 14, Record length: 106, Not Compressed Data records: 47, bytes used: 4982 (0%) average length: 106 ------------------------------------ Logical area: RDBVMS$INTERRELATIONS for storage area : RDB$SYSTEM Larea id: 24, Record type: 15, Record length: 192, Not Compressed Data records: 1119, bytes used: 213729 (4%) average length: 191 ------------------------------------ Logical area: RDBVMS$STO_MAP_MAP_NAM_NDX for storage area : RDB$SYSTEM Larea id: 25, Record type: 0, Record length: 214, Not Compressed Data records: 13, bytes used: 5246 (0%) average length: 404 ------------------------------------ Logical area: RDBVMS$STO_MAP_AREA_MAP_NDX for storage area : RDB$SYSTEM Larea id: 26, Record type: 0, Record length: 214, Not Compressed Data records: 17, bytes used: 5368 (0%) average length: 316 ------------------------------------ Logical area: RDBVMS$INTER_REL_FLD_NDX for storage area : RDB$SYSTEM Larea id: 27, Record type: 0, Record length: 214, Not Compressed Data records: 649, bytes used: 145166 (3%) average length: 224 ------------------------------------ Logical area: RDBVMS$COLLATIONS for storage area : RDB$SYSTEM Larea id: 28, Record type: 16, Record length: 54, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: RDBVMS$COLLATIONS_NDX for storage area : RDB$SYSTEM Larea id: 29, Record type: 0, Record length: 214, Not Compressed Data records: 1, bytes used: 428 (0%) average length: 428 ------------------------------------ Logical area: RDBVMS$TRIGGERS for storage area : RDB$SYSTEM Larea id: 30, Record type: 17, Record length: 108, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: RDBVMS$TRG_TRIGGER_NAME_NDX for storage area : RDB$SYSTEM Larea id: 31, Record type: 0, Record length: 214, Not Compressed Data records: 2, bytes used: 856 (0%) average length: 428 ------------------------------------ Logical area: RDBVMS$RELATION_CONSTRAINTS for storage area : RDB$SYSTEM Larea id: 32, Record type: 18, Record length: 146, Not Compressed Data records: 373, bytes used: 54458 (1%) average length: 146 ------------------------------------ Logical area: RDBVMS$RLC_CONSTRAINT_NAME_NDX for storage area : RDB$SYSTEM Larea id: 33, Record type: 0, Record length: 214, Not Compressed Data records: 113, bytes used: 41686 (1%) average length: 369 ------------------------------------ Logical area: RDBVMS$RELATION_CONSTRAINT_FLDS for storage area : RDB$SYSTEM Larea id: 34, Record type: 19, Record length: 70, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: RDBVMS$RCF_CONSTRAINT_NAME_NDX for storage area : RDB$SYSTEM Larea id: 35, Record type: 0, Record length: 214, Not Compressed Data records: 1, bytes used: 428 (0%) average length: 428 ------------------------------------ Logical area: RDBVMS$PRIVILEGES for storage area : RDB$SYSTEM Larea id: 36, Record type: 20, Record length: 30, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: RDBVMS$PRV_REL_ID_NDX for storage area : RDB$SYSTEM Larea id: 37, Record type: 0, Record length: 214, Not Compressed Data records: 1, bytes used: 428 (0%) average length: 428 ------------------------------------ Logical area: RDBVMS$PRV_FLD_ID_NDX for storage area : RDB$SYSTEM Larea id: 38, Record type: 0, Record length: 214, Not Compressed Data records: 1, bytes used: 428 (0%) average length: 428 ------------------------------------ Logical area: RDB$AIP for storage area : RDB$SYSTEM Larea id: 16385, Record type: 0, Record length: 958, Not Compressed Data records: 32, bytes used: 30656 (1%) average length: 958 ------------------------------------------------------------------------------ Storage analysis for storage area: AB_BOM - file: $1$DUA29:[MACPAC.V614.RDB]AB_BOM.RDA;1 Area_id: 2, Page length: 2560, Last page: 1009 Bytes free: 2507977 (97%), bytes overhead: 75063 (3%) Spam count: 1, AIP count: 0, ABM count: 12 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_BOM for storage area : AB_BOM Larea id: 58, Record type: 21, Record length: 275, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_CHG_DOC - file: $1$DUA29:[MACPAC.V614.RDB]AB_CHG_DOC.RDA;1 Area_id: 3, Page length: 1024, Last page: 1025 Bytes free: 911690 (87%), bytes overhead: 137910 (13%) Spam count: 1, AIP count: 0, ABM count: 96 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: CHD_INDX1 for storage area : AB_CHG_DOC Larea id: 51, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: CHD_INDX2 for storage area : AB_CHG_DOC Larea id: 52, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_CHG_DOC for storage area : AB_CHG_DOC Larea id: 59, Record type: 22, Record length: 102, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_CONF_ITEM - file: $1$DUA29:[MACPAC.V614.RDB]AB_CONF_ITEM.RDA;1 Area_id: 4, Page length: 1024, Last page: 1025 Bytes free: 911690 (87%), bytes overhead: 137910 (13%) Spam count: 1, AIP count: 0, ABM count: 96 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: CIS_INDX1 for storage area : AB_CONF_ITEM Larea id: 53, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: CIS_INDX2 for storage area : AB_CONF_ITEM Larea id: 54, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_CONF_ITEM for storage area : AB_CONF_ITEM Larea id: 60, Record type: 23, Record length: 86, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_DW - file: $1$DUA29:[MACPAC.V614.RDB]AB_DW.RDA;1 Area_id: 5, Page length: 1024, Last page: 1025 Bytes free: 849098 (81%), bytes overhead: 200502 (19%) Spam count: 1, AIP count: 0, ABM count: 160 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: DWH_INDX1 for storage area : AB_DW Larea id: 55, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: DWD_INDX1 for storage area : AB_DW Larea id: 56, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: DWD_INDX2 for storage area : AB_DW Larea id: 57, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_DW_HDR for storage area : AB_DW Larea id: 61, Record type: 24, Record length: 181, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_DW_DTL for storage area : AB_DW Larea id: 62, Record type: 25, Record length: 162, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_AB_EXCP - file: $1$DUA29:[MACPAC.V614.RDB]AB_AB_EXCP.RDA;1 Area_id: 6, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_AB_EXCP for storage area : AB_AB_EXCP Larea id: 63, Record type: 26, Record length: 267, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_AD_EXCP - file: $1$DUA29:[MACPAC.V614.RDB]AB_AD_EXCP.RDA;1 Area_id: 7, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_AD_EXCP for storage area : AB_AD_EXCP Larea id: 64, Record type: 27, Record length: 267, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_ALT_PART - file: $1$DUA29:[MACPAC.V614.RDB]AB_ALT_PART.RDA;1 Area_id: 8, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_AB_ALT_PART for storage area : AB_ALT_PART Larea id: 65, Record type: 28, Record length: 204, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_BOM_INDX1 - file: $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX1.RDA;1 Area_id: 9, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: ABB_INDX1 for storage area : AB_BOM_INDX1 Larea id: 47, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_BOM_INDX2 - file: $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX2.RDA;1 Area_id: 10, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: ABB_INDX2 for storage area : AB_BOM_INDX2 Larea id: 48, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_BOM_INDX3 - file: $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX3.RDA;1 Area_id: 11, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: ABB_INDX3 for storage area : AB_BOM_INDX3 Larea id: 49, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: AB_BOM_INDX4 - file: $1$DUA29:[MACPAC.V614.RDB]AB_BOM_INDX4.RDA;1 Area_id: 12, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: ABB_INDX4 for storage area : AB_BOM_INDX4 Larea id: 50, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_INSPEC - file: $1$DUA29:[MACPAC.V614.RDB]QA_INSPEC.RDA;1 Area_id: 13, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_INSPEC for storage area : QA_INSPEC Larea id: 82, Record type: 29, Record length: 30, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_NONCON - file: $1$DUA29:[MACPAC.V614.RDB]QA_NONCON.RDA;1 Area_id: 14, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_NONCON for storage area : QA_NONCON Larea id: 83, Record type: 30, Record length: 375, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_SQUAWK - file: $1$DUA29:[MACPAC.V614.RDB]QA_SQUAWK.RDA;1 Area_id: 15, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_SQUAWK for storage area : QA_SQUAWK Larea id: 84, Record type: 31, Record length: 527, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_EFFECT - file: $1$DUA29:[MACPAC.V614.RDB]QA_EFFECT.RDA;1 Area_id: 16, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_EFFECT for storage area : QA_EFFECT Larea id: 85, Record type: 32, Record length: 30, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_CAAGE - file: $1$DUA29:[MACPAC.V614.RDB]QA_CAAGE.RDA;1 Area_id: 17, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_CAAGE for storage area : QA_CAAGE Larea id: 86, Record type: 33, Record length: 43, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_SERNBR - file: $1$DUA29:[MACPAC.V614.RDB]QA_SERNBR.RDA;1 Area_id: 18, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_SERNBR for storage area : QA_SERNBR Larea id: 87, Record type: 34, Record length: 99, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_NONAGE - file: $1$DUA29:[MACPAC.V614.RDB]QA_NONAGE.RDA;1 Area_id: 19, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_NONAGE for storage area : QA_NONAGE Larea id: 88, Record type: 35, Record length: 41, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_PDDISP - file: $1$DUA29:[MACPAC.V614.RDB]QA_PDDISP.RDA;1 Area_id: 20, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_QA_PDDISP for storage area : QA_PDDISP Larea id: 89, Record type: 36, Record length: 91, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: QA_INDICES - file: $1$DUA29:[MACPAC.V614.RDB]QA_INDICES.RDA;1 Area_id: 21, Page length: 1024, Last page: 1025 Bytes free: 755210 (72%), bytes overhead: 294390 (28%) Spam count: 1, AIP count: 0, ABM count: 256 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: INSPEC_INDEX for storage area : QA_INDICES Larea id: 74, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TNC_INDEX for storage area : QA_INDICES Larea id: 75, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TSQ_INDEX for storage area : QA_INDICES Larea id: 76, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: EFFECT_INDEX for storage area : QA_INDICES Larea id: 77, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TAC_INDEX for storage area : QA_INDICES Larea id: 78, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TSN_INDEX for storage area : QA_INDICES Larea id: 79, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TAN_INDEX for storage area : QA_INDICES Larea id: 80, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TPD_INDEX for storage area : QA_INDICES Larea id: 81, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: OTH_FM - file: $1$DUA29:[MACPAC.V614.RDB]OTH_FM.RDA;1 Area_id: 22, Page length: 4096, Last page: 2001 Bytes free: 7970558 (97%), bytes overhead: 125188 (2%) Spam count: 1, AIP count: 0, ABM count: 8 Data records: 347, bytes used: 100350 (1%) average length: 289, compression ratio: .33 index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_OTH_FM for storage area : OTH_FM Larea id: 98, Record type: 37, Record length: 884, Compressed Data records: 347, bytes used: 100350 (1%) average length: 289, compression ratio: .33 ------------------------------------------------------------------------------ Storage analysis for storage area: OTH_VDA - file: $1$DUA29:[MACPAC.V614.RDB]OTH_VDA.RDA;1 Area_id: 23, Page length: 3584, Last page: 2008 Bytes free: 7021328 (98%), bytes overhead: 122776 (2%) Spam count: 1, AIP count: 0, ABM count: 9 Data records: 226, bytes used: 52568 (1%) average length: 233, compression ratio: .13 index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_OTH_VDA for storage area : OTH_VDA Larea id: 99, Record type: 38, Record length: 1744, Compressed Data records: 226, bytes used: 52568 (1%) average length: 233, compression ratio: .13 ------------------------------------------------------------------------------ Storage analysis for storage area: OTH_PRT - file: $1$DUA29:[MACPAC.V614.RDB]OTH_PRT.RDA;1 Area_id: 24, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_OTH_PRT for storage area : OTH_PRT Larea id: 100, Record type: 39, Record length: 48, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: OTH_INDICES - file: $1$DUA29:[MACPAC.V614.RDB]OTH_INDICES.RDA;1 Area_id: 25, Page length: 1024, Last page: 1025 Bytes free: 740148 (71%), bytes overhead: 203212 (19%) Spam count: 1, AIP count: 0, ABM count: 160 Data records: 271, bytes used: 106240 (10%) average length: 392, compression ratio: 1.00 index records: 271, bytes used: 106240 (10%) B-Tree: 88772, Hash: 0, Duplicate: 17468, Overflow: 0 ------------------------------------ Logical area: FM_INDEX for storage area : OTH_INDICES Larea id: 93, Record type: 0, Record length: 215, Not Compressed Data records: 20, bytes used: 8560 (1%) average length: 428 ------------------------------------ Logical area: FM_INDEX2 for storage area : OTH_INDICES Larea id: 94, Record type: 0, Record length: 215, Not Compressed Data records: 146, bytes used: 54956 (5%) average length: 376 ------------------------------------ Logical area: VDA_INDEX for storage area : OTH_INDICES Larea id: 95, Record type: 0, Record length: 215, Not Compressed Data records: 11, bytes used: 4708 (0%) average length: 428 ------------------------------------ Logical area: VDA_INDEX2 for storage area : OTH_INDICES Larea id: 96, Record type: 0, Record length: 215, Not Compressed Data records: 94, bytes used: 38016 (4%) average length: 404 ------------------------------------ Logical area: PRT_INDEX for storage area : OTH_INDICES Larea id: 97, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: MS_BAS - file: $1$DUA29:[MACPAC.V614.RDB]MS_BAS.RDA;1 Area_id: 26, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_MS_BAS for storage area : MS_BAS Larea id: 105, Record type: 40, Record length: 50, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: MS_DET - file: $1$DUA29:[MACPAC.V614.RDB]MS_DET.RDA;1 Area_id: 27, Page length: 1024, Last page: 1025 Bytes free: 974282 (93%), bytes overhead: 75318 (7%) Spam count: 1, AIP count: 0, ABM count: 32 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: TBL_MS_DET for storage area : MS_DET Larea id: 106, Record type: 41, Record length: 122, Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------ Storage analysis for storage area: MS_INDICES - file: $1$DUA29:[MACPAC.V614.RDB]MS_INDICES.RDA;1 Area_id: 28, Page length: 1024, Last page: 1025 Bytes free: 942986 (90%), bytes overhead: 106614 (10%) Spam count: 1, AIP count: 0, ABM count: 64 Data records: 0, bytes used: 0 (0%) index records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: BASINDX for storage area : MS_INDICES Larea id: 103, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------ Logical area: DETINDX for storage area : MS_INDICES Larea id: 104, Record type: 0, Record length: 215, Not Compressed Data records: 0, bytes used: 0 (0%) ------------------------------------------------------------------------------
1120.10	Call MACPAC developers	KCOHUB::DAZOFF::DUNCAN	Gerry Duncan @KCO, 452-3445	`Mon Mar 30 1992 22:44`	11
	My two cents worth .... I would immediately engage the author's of MACPAC (Andersen Consulting I believe) as ask them to help. While you can continue to try to find the problem, you're probably going to have to get the author(s) of the software to alter their queries, page structure, start_txn statements, indexes, etc. Have you contacted anyone at MACPAC ? It seems this would be an early tactic to help through this problem. -- gerry
1120.11	Disk I/O Rate?	33054::BOWERS	Dave Bowers @WHO	`Tue Mar 31 1992 00:49`	7
	>> All of the Rdb database files reside on the same disk as do all of >> the DBMS files. Have you looked at MONITOR DISK? What's the aggregate I/O rate on DUA29? With everything located on a single drive that's the first place I'd look. -dave
1120.12	Charge Your Customer for this work!	TRCOA::MCMULLEN	Ken McMullen	`Tue Mar 31 1992 00:54`	19
	Patti, I sure hope you are not providing all this information to the customer for free. We are in the consulting/services business. Unless we start selling services like application/database design/tuning, there will be more layoffs, the stock will not go up, no raises for the remaining. We should not feel responsible for someone elses poor implementation. We will gladly help, but we MUST charge a fee for a valued service. Now, if your customer is willing to pay my expenses and the normal Digital consulting rate, give me a call. regards, Ken McMullen
1120.13	Buffer size rather high??	SOS6::LECORE	Guy, Database Country Support France	`Wed Apr 01 1992 12:04`	22
	1) A buffer size of 64 blocks seems pretty high for a database whose areas have pages sizes of 2, 5 (!), 7 (!), and 8. Couldn't the pages sizes be aligned to 2, 4 or 8, and the buffer size set accordingly - as low as possible - say 8 ? All those 64 block read I/Os are going to be pretty slow... 2) In the root file I see : Buffer count is 256, each is 64 blocks long... If I calculate right, 256*64 = 16384 - i.e. 8 Mb of buffer pool per user ! Is there much paging activity on the system ? 3) The file I/O stats show that DUA29 is running pretty slow - 77ms average access time is not so good - long I/O request queues ?? 64 block I/O operations ?? - that's worth about 20 French Francs - who should I cross charge to ?? (joke...) Have fun, Guy
1120.14	We've been throught this before ...	CIMNET::EGGIMANN		`Wed Apr 01 1992 22:19`	22
	I'm just catching up on the activity with this note, but let me start by indicating that I agree with .12 which identified an opportunity to generate consulting business to deliver a solution to MDC. I can send the trip reports offline with the specifics, but we reviewed Andersen's MACPAC/D DBMS and Rdb database and supplied them with logical and physical design recommendations. Some of these recommendations were implemented, others were not. These engineering services are free to CSO's during the development of the application, but once the application goes into end user engagements, we require Andersen or the customer to fund our services. Patti - If the local engagement partner for Andersen, or MDC want to fund us to work with Andersen to solve this problem, we're ready to go. Since I know most of the IT folks out there from the DBMS and performance work, let me know if you want me to talk directly to Keith or his folks. Let me know how you want to proceed. Regards, Pete
1120.15	Andersen feedback	STOHUB::GOLFNG::DONOVAN	Patti Donovan, 445-6390	`Wed Apr 08 1992 00:09`	45
	Thanks for all the suggestions so far. Who supports Andersen Consulting in Chicago? I have talked with several people so far, most recently a Norm Beard, (312) 507-2658, who is Andersen's Rdb person. Here's what Norm told the customer: 1. All of the transactions were started READ_WRITE even those for INQUIRY only. This will be changed in the next release. (This is not a surprise, we thought that most of the problems were application related). 2. Move the indexes to a different area from the actual data. The customer will eventually spread the db over many disks, but thought that with a 33 VUP machine and the latest in disk technology, this should not yet be an issue. The customer agreed to move the indexes first and remove the index with 14 fields which we decided wasn't doing any good. He also agreed to do a monitor disk to determine if it was I/O bound. 3. The customer has not been able to get RDMS$DEBUG_FLAGS to work. He is going to pursue this with the Support Center. I also suggested that Andersen use this as well. 4. I have strongly suggested to the customer and Andersen that they use DECtrace and RdbExpert to tune the database. Pete - I passed Keith's message on to the local sales rep. The customer has not paid for MACPAC yet because of the poor quality and lack of performance. They have had the software since July of '90. I think that the sale needs to be made to Andersen that if they want to get paid for this software, they need to use our services and/or our tools to tune the application. Then after the customer buys the MACPAC product, we can sell the customer our tuning services as needed. The customer did mention that an ANALYZE/PLACEMENT should that it's taking an average of 15 I/O's to the RDB$RELATIONS table to get a record. What is normal for this? He didn't give me more specifics on what he was trying to do. I also suggested that he reduce the buffer size, but they didn't tell me what difference that made. Andersen also said they were going to tune the servers by whether they were used for inquiry or update. Regards, Patti
1120.16	Andersen Support	KCOHUB::DAZOFF::DUNCAN	Gerry Duncan @KCO, 452-3445	`Thu Apr 09 1992 16:46`	33
	Ultimately ME ... but read on ... Until recently, Andersen was, I believe, a CSH. This relationship to Digital would be like the one Oracle has with us (ie, Digital wants both of these companies to support our technology etc.). As far as I can tell, a CSH type customer would get their Rdb support primarily from the RSVP program. Normally, neither the end user or channels groups would get heavily involved with CSH types of customers. There's just too many CSHs around and, for the most part, they shouldn't need much technical help. However, I have felt for a long time that Rdb application vendors would eventually need more assistance.) On the other hand, if the company (Andersen in this case) resells Digital hardware and related products, their support would come through US Channels sales support and RSVP. (Remember, we're still a hardware company and that's where most of the channels business is at the moment.) I believe Andersen has signed an agreement with Digital to move hardware. So, that would open up a chance for channels database people (like me) to work with Andersen. I have extracted pieces of this note and forwarded to channels people in Chicago. I'll try to followup next week to see if there is any interest on Andersen's part to talk about these kinds of situations. I know that there is a full court press happening now to encourage Andersen (and all OEMs) to resell Digital services of all kinds. So, you and your customer push from your side, we'll push from the channels side and see what happens. -- gerry