Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
blobspace_free.sql | 2020-05-11 | 909 Bytes | |
buff_btr_ratio.sql | 2020-05-11 | 791 Bytes | |
buff_cach_ratio.sql | 2020-05-11 | 674 Bytes | |
buff_cach_sum.sql | 2020-05-11 | 841 Bytes | |
checkpointhistory.sql | 2020-05-11 | 440 Bytes | |
chunk_free_list.sql | 2020-05-11 | 811 Bytes | |
chunk_io_stat.sql | 2020-05-11 | 873 Bytes | |
chunk_io_sum.sql | 2020-05-11 | 1.6 kB | |
chunk_status.sql | 2020-05-11 | 1.5 kB | |
chunkio.sql | 2020-05-11 | 775 Bytes | |
chunklayout.sql | 2020-05-11 | 679 Bytes | |
database_list.sql | 2020-05-11 | 623 Bytes | |
database_size.sql | 2020-05-11 | 590 Bytes | |
dbspace_blob_free.sql | 2020-05-11 | 718 Bytes | |
dbspace_free.sql | 2020-05-11 | 882 Bytes | |
dbwho.sh | 2020-05-11 | 792 Bytes | |
dbwho.sql | 2020-05-11 | 748 Bytes | |
iohistory.sql | 2020-05-11 | 437 Bytes | |
licensehistory.sql | 2020-05-11 | 490 Bytes | |
log_position.sql | 2020-05-11 | 974 Bytes | |
log_statistics.sql | 2020-05-11 | 1.1 kB | |
log_transaction.sql | 2020-05-11 | 1.2 kB | |
logicallogs.sql | 2020-05-11 | 916 Bytes | |
machineinfo.sql | 2020-05-11 | 433 Bytes | |
memsegments.sql | 2020-05-11 | 1.1 kB | |
README.txt | 2020-05-11 | 3.9 kB | |
server_onconfig.sql | 2020-05-11 | 551 Bytes | |
server_readahead.sql | 2020-05-11 | 1.1 kB | |
server_statics.sql | 2020-05-11 | 1.3 kB | |
server_uptime.sql | 2020-05-11 | 940 Bytes | |
session_list.sql | 2020-05-11 | 524 Bytes | |
session_locks.sql | 2020-05-11 | 1.5 kB | |
session_lockwait.sql | 2020-05-11 | 1.4 kB | |
session_statistics.sql | 2020-05-11 | 991 Bytes | |
session_wait_list.sql | 2020-05-11 | 643 Bytes | |
smiversion.sql | 2020-05-11 | 444 Bytes | |
sql_statistics.sql | 2020-05-11 | 582 Bytes | |
sqlhosts.sql | 2020-05-11 | 490 Bytes | |
syslicense.sql | 2020-05-11 | 460 Bytes | |
sysrstcb.sql | 2020-05-11 | 428 Bytes | |
syssqexplain.sql | 2020-05-11 | 656 Bytes | |
table_disk_layout.sql | 2020-05-11 | 727 Bytes | |
table_extent_plan.sql | 2020-05-11 | 1.2 kB | |
table_io_statistics.sql | 2020-05-11 | 703 Bytes | |
table_with_extents.sql | 2020-05-11 | 650 Bytes | |
table_with_seqscans.sql | 2020-05-11 | 839 Bytes | |
tableextents.sql | 2020-05-11 | 704 Bytes | |
tableinfo_freerows.sql | 2020-05-11 | 1.3 kB | |
tableseqscans.sql | 2020-05-11 | 667 Bytes | |
vp_profile.sql | 2020-05-11 | 602 Bytes | |
vp_statistics.sql | 2020-05-11 | 701 Bytes | |
vpcpustats.sql | 2020-05-11 | 428 Bytes | |
Totals: 52 Items | 45.5 kB | 0 |
----------------------------------------------------------------------------- -- Module: @(#)README 2.4 Date: 2015/03/24 -- Author: Lester Knutsen Email: lester@advancedatatools.com -- Advanced DataTools Corporation -- Discription: This is a set of SQL scripts that use the sysmaster -- database to provide information on the status of your server ----------------------------------------------------------------------------- -- New Scripts checkpointhistory.sql - Display checkpoint history chunkio.sql - Display IO by chunk chunklayout.sql - Display layout of what is in a chunk iohistory.sq - Display chunk I/O hostory for the past hourl licensehistory.sql - Display Informix Usages history logicallogs.sql - Display Logical Logs machineinfo.sql - Display information about the hardware and OS memsegments.sql - Display Informix Memory Segments smiversion.sql - Display Sysmaster Version sqlhosts.sql - Display SQL hosts file syslicense.sql - Display data from the license table` sysrstcb.sqla - Display all threads syssqexplain.sql - Display Query Stats tableextents.sql - Display data about tables and extents tableinfo_freerows.sql - Display data about tables and free row space tableseqscans.sql - Display table scans vpcpustats.sql - Display more Oninit VP stats -- Orginal Scripts buff_btr_ratio.sql - Display Buffer Turnovers per hour buff_cach_ratio.sql - Display Buffer read and write cache ratios by buffer pool buff_cach_sum.sql - Displays % of reads and writes from buffers chunk_free_list.sql - Displays free space within a chunk chunk_io_stat.sql - Displays chunk IO statistics chunk_io_sum.sql - Displays chunk IO percent of total IO ordered by chunk chunk_status.sql - Displays info and status for a chunk database_list.sql - Displays database list,owner and logging status database_size.sql - Displays size of database based on pages allocated dbspace_blob_free.sql - Display number of free blob pages in blobspace dbspace_free.sql - Displays free space in all dbspaces like Unix "df -k " command dbwho.sh - Displays who is using what database dbwho.sql - Displays who is using what database log_position.sql - Displays users and position in logical logs log_statistics.sqla - Displays how many open transactions are in each log. log_transaction.sql - Displays how many open transactions are in each log. server_onconfig.sql - Displays boot and effective configuration parameters server_readahead.sql - Calculate the percent of read ahead used server_statics.sql - Displays key server profile/perfomance statatics server_uptime.sql - Displays server uptime and when the stats were last reset session_list.sql - Displays short list of user sessions session_locks.sql - Displays locks, users and tables session_lockwait.sql - Displays Only locks with other users waiting on them session_statistics.sql - Displays user session profile info session_wait_list.sql - Displays session wait status sql_statistics.sql - Displays users SQL statement table_disk_layout.sql - Displays tables and extents table_extent_plan.sqla - Display extents and proposed new extent sizes table_io_statistics.sql - Displays table IO performance table_with_extents.sql - Displays tables, number of extents and size of table table_with_seqscans.sql - Displays tables with sequence scans vp_profile.sql - Displays VP status vp_statistics.sql - Displays VP status like onstat -g sch ------------------------------------------------------------------------------- Lester Knutsen Advanced DataTools Corporation 4216 Evergreen Lane, #126 Annandale, VA 22003 USA 703-256-0267 lester@advancedatatools.com www.advancedatatools.com -------------------------------------------------------------------------------