RE: No SYSTABAUTH Record for TBLSpace ...
Never mind. I believe I simply need to add a table-based grant statement
for the tables which recorded this type of error.
Take care.
Clifton
_____
From: Clifton Bean [mailto:cbean@ctm.com]
Sent: Saturday, January 20, 2007 5:20 PM
To: 'ids@iiug.org'
Subject: No SYSTABAUTH Record for TBLSpace ...
ONLINE 5.20.UC3
AIX 5.2
I am getting several of the following type errors when running tbcheck cc
this evening:
ISAM error: no record found.
WARNING:No systabauth record for TBLSpace root.wait_ix.
TBLSpace name wait_ix
Owner root
TBLSpace number 4000164
Tabid 848
Row size 4
Number of columns 1
Number of indexes 1
Number of rows 0
Date created 09/30/2006
TBLSpace major version number 848
TBLSpace minor version number 115
TBLSpace type T
Locking level P
Number of pages used 0
First extent size 32
Next extent size 32
Flags 0
Site
Database name ò)t/ò)
Does anyone recall the fix is for this type warning?
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
1431 Greenway Drive #700
Irving, Texas 75038
Main (972) 812-1411 x244
Toll Free (800) 834-8807 x244
Fax (469) 417-0665