Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Home / DBAdmin-Tools / Sysmaster2015 / sysmaster2015
Name Modified Size InfoDownloads / 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
-------------------------------------------------------------------------------


Source: README.txt, updated 2020-05-11