Re: Does Informix 6.0 and beyond provides data dictionary information?

allau@sequent.com (Al Lau) writes: >Hi, >I'm interested in knowing what kind of information is available for the >online data dictionary. I have not seen the 6.0 documentation and wonder >if there is a way (Online 6.0 and beyong) to query the online interactively >and get a list of all those chunk locations (full path name of the unix >file, either cooked or raw) I added for all databases? The System Monitoring Interface (SMI) that OnLine DSA products support, provides you with the following topics: Auditing Disk Usage User Profiling Database Logging Status Tables Chunks Chunk I/O Dbspaces Locks Extents Virtual processor CPU usage System profiling >Is the online backup of 6.0 better than the tbtape in online 5.0? Any >information will be greatly appreciated. OnLine 6.0 still provides you with the tbtape facility. In addition, 6.0 has added On-Archive which is a "mainframe" caliber approach to data archiving/restoration. You can set up unattended archives, permissions for archive execution, perform cold (offline) and warm (online) restore operations, etc. Troy ============================================================================== Troy L. Hewitt, CSE INFORMIX-Tampa Client Services Tampa, Florida (813) 971-0010 e-mail: troy@informix.com ------------------------------------------------------------------------------ - All opinions expressed are my own and not those of Informix Software, Inc. - ==============================================================================