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 / utils_ak
Name Modified Size InfoDownloads / Week
Parent folder
aspace 2020-05-11 6.7 kB
dbsavail.ec 2020-05-11 4.2 kB
dbsavail.p2 2020-05-11 2.3 kB
dbsavail.sh 2020-05-11 297 Bytes
dbsavail.sh.64bit 2020-05-11 379 Bytes
dbstruct.ec 2020-05-11 14.6 kB
defragtable.ec 2020-05-11 9.2 kB
lschunks.awk 2020-05-11 39.9 kB
printchunks 2020-05-11 168 Bytes
printchunks.p 2020-05-11 1.4 kB
README 2020-05-11 4.6 kB
Totals: 11 Items   83.8 kB 0
Here are several utilities that I find useful and wished to share with the
Informix community.  Most I have written, others were written for us by
Informix support personnel under contract, proper attribution is given below. 



  ----------------------------------------------------------------------------

Utility: aspace
Synopsis: Replacement/wrapper for tbspace/onspaces which can track chunks
	across multiple instances preventing overlapping chunks from being
	added even if the new chunk overlaps a chunk in another instance or 
	is a symbolic link pointing to a device/file already being used.
Author(s): Jacob Salomon
	   Art S. Kagel
Version(s) supported: Online 5.0x, ODS 6, ODS 7.xx+.
File(s): aspace		- User script - requires KSH or BASH.
	 lschunks.awk	- Underlying awk script.
	 printchunks    - script to report on the aspace database's contents
			  grouped by server (TBCONFIG/ONCONFIG value).
	 printchunks.p  - perl script that does the formatting for printchunks.
         .chunkList	- <Created> Current aspace database file.
	 .chunkList.bu.*- <Created> Historical aspace database files.
Comments: Only need to be careful if you have 5.0x and 6/7 versions on the
	same machine to unset TBCONFIG when working on the 6/7 instance or
	ONCONFIG when working on the 5.0x instance so that aspace does not
	get confused.  

Usage:  Use the -AA option to create the initial database of existing chunks. 
	This needs to be run against each engine on the machine.  Once the 
	database exists it will be maintained EXCEPT after deleting chunks or 
	dbspaces since aspace does not implement the onspace -d option you 
	will have to delete the .chunkList file and run aspace -AA again 
	against each engine after a drop.  The -CC option is a test to see if 
	a chunk would create a conflict and -CI can be used to force in a 
	chunk added via onspaces or onmonitor.  Aspace supports the onspaces 
	-c and -a options and calls onspaces after checking for conflicts, if 
	onspaces reports success (it may fail for example if the device is not 
	large enough to hold the chunk or if the filesystem for a COOKED chunk
	is too full) then aspace updates its database (the .chunkList file).
	Note that major/minor numbers of device files sometimes change between 
	boots depending on the OS and volume manager, if this happens the next 
	time you run aspace it will update the database with the new numbers 
	before checking for any conflict, this is noted with a warning about
	each such chunk.  The check and update can be forced using aspace -CV.

  ----------------------------------------------------------------------------

Utility: dbsavail.ec
Synopsis: Printout total space and available space by dbspace name with total.
	Creates a stored procedure, dbsavail() to do most work and you can 
	execute that directly also to see the report.
Author(s): Art S. Kagel
Version(s) supported: 7.0x
File(s): dbsavail.ec
Comments: There is a shell/perl script version of this included also which 
	works on 5.0x.  Since the script is based on onstat/tbstat it is
	only up to date as of the last time the reserved pages were flushed.


  ----------------------------------------------------------------------------

Utility: dbsavail.sh
Synopsis: Printout total space and available space by dbspace name with total.
Author(s): Art S. Kagel
	   Jake Salomon
Version(s) supported: 5.0x/6.0x/7.xx+
File(s): dbsavail.sh
	 dbsavail.sh.64bit
	 dbsavail.p2
Comments: Requires a UNIX-like sort utility, KSH, and PERL.
	If you have a 64bit version of IDS (versions ending in .FC*) you 
	will need to use the .64bit version of the script as the format of 
	the onstat report it interprets has changed in those releases.

  ----------------------------------------------------------------------------

Utility: dbstruct.ec
Synopsis: Produces "C", ESQL/C, and structured FORTRAN data structures from a
	database/table schema.
Author(s): Art S. Kagel
Version(s) supported: 5.0x/6/7.xx+
File(s): dbstruct.ec
Comments:

  ----------------------------------------------------------------------------

Utility: defragtable.ec
Synopsis: Compresses a table causing the table to live in as few extents as 
	possible.
Author(s): Art S. Kagel
Version(s) supported: 5.0x/6/7.xx+
File(s): defragtable.ec
Comments:


  ----------------------------------------------------------------------------

Utility: dostats.ec

Dostats has been removed.  An updated version is part of the package
utils2_ak the version formerly included here was seriously outdated. 

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