Re: Does Informix 6.0 and beyond provides data dictionary information?
but where do you get to enter the data describes each table and column, etc... } } 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. - } ============================================================================== } -- regards, +----------------------------------------------------------------------------+ | . . | Bob Baskett | | ... ... | Software Engineer | | ..... ..... | Business Systems Integration Group | | .. ... .. | Semiconductor Products Sector | | . . . | Mesa, AZ | | | President, Informix Users Group Of Arizona | | Motorola, Inc. | | +----------------------------------------------------------------------------+ | Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1 | +----------------------------------------------------------------------------+