Conference azur::mcc

5638.0. "Database corruption?" by GLDOA::KATZ (Follow your conscience) Tue Oct 05 1993 15:47

I am having trouble with a database that MCC is supposed to use
for interface information. About 2 months ago we had a person 
come in and look at out system. It was decided that for performance
reasons the MCC database should be split up thus we have a
database for snmp information and one for interface information.
The databases are on seperate disks. I was running a command procedure
that removes rows of data created before a chose date. This procedure
works on the basis of time_stamp. Basically delete all data
before the time_stamp date. The procedure deleted 6000 rows/columns
from the snmp database but failed to delete one from the interface
database.  Looking into this problem I found no indexes in
the interface database and both databases are now the same size
eve though the command files that export data point to different
databases. 

1. How do I get indexes back into the interface database?
2. Why are both databases the same size?
3. Is there a specific way to create multiple databases with MCC
that is documented somewhere? Thanks.

		-Jim-

PS: Colorado asked me to post this because they had no answers.



$ define sql$database dka300:[netmgr]SNMP.RDB
$ mc sql$
SQL> show indexes
User indexes in database with filename SQL$DATABASE
     MCC_SNMP_TIME 
     MCC_SNMP_IP_TIME 
     MCC_SNMP_TCP_TIME 
SQL> show database
Default alias:
    Rdb/VMS database in file SQL$DATABASE
SQL> exit

$ define sql$database dka700:[netmgr]INTERFACE.RDB
%DCL-I-SUPERSEDE, previous value of SQL$DATABASE has been superseded
$ mc sql$
SQL> show index
User indexes in database with filename SQL$DATABASE
No indexes found
 
SQL> show database
Default alias:
    Rdb/VMS database in file SQL$DATABASE
SQL> exit

dir dka700:[netmgr]*.rdb/size

Directory DKA700:[NETMGR]

INTERFACE.RDB;1      295534

Total of 1 file, 295534 blocks.
$ dir dka300:[netmgr]*.rdb/size

Directory DKA300:[NETMGR]

SNMP.RDB;1           295534

Total of 1 file, 295534 blocks.
$ dir dka300:[netmgr]*.rdb/size/full

Directory DKA300:[NETMGR]

SNMP.RDB;1                    File ID:  (19,1,0)           
Size:       295534/295536     Owner:    [401,1]
Created:  23-JUL-1993 10:06:49.53
Revised:   5-OCT-1993 14:22:39.51 (170)
Expires:   <None specified>
Backup:    <No backup recorded>
File organization:  Sequential
File attributes:    Allocation: 295536, Extend: 0, Global buffer count: 0
                    No version limit, Contiguous best try
Record format:      Undefined
Record attributes:  None
RMS attributes:     None
Journaling enabled: None
File protection:    System:RWED, Owner:R, Group:, World:
Access Cntrl List:  None

Total of 1 file, 295534/295536 blocks.

$ dir dka700:[netmgr]*.rdb/size/full

Directory DKA700:[NETMGR]

INTERFACE.RDB;1               File ID:  (1597,13,0)        
Size:       295534/295536     Owner:    [401,1]
Created:   1-SEP-1993 15:16:11.14
Revised:   5-OCT-1993 14:23:16.82 (132)
Expires:   <None specified>
Backup:    <No backup recorded>
File organization:  Sequential
File attributes:    Allocation: 295536, Extend: 0, Global buffer count: 0
                    No version limit, Contiguous best try
Record format:      Undefined
Record attributes:  None
RMS attributes:     None
Journaling enabled: None
File protection:    System:RWED, Owner:R, Group:, World:
Access Cntrl List:  None

$dtr
DTR> show databases
Databases:
        * EXP_INTERFACE;1               * EXP_SNMP;1

DTR> show exp_interface
Relational database EXP_INTERFACE :
DKA700:[NETMGR]INTERFACE.RDB;1

DTR> show exp_snmp
Relational database EXP_SNMP :
DKA300:[NETMGR]SNMP.RDB;1
                        

% ====== Internet headers and postmarks (see DECWRL::GATEWAY.DOC) ======
% Received: by aries.det.dec.com (5.65/ULTRIX-fma-073190) id AA23823; Tue, 5 Oct 1993 14:39:56 -040
% From: aries::katz (Jim Katz/Network Consultant)
% To: gldoa::katz
% Subject: sethost