Downloads for IDS
Last updated Jan, 2006
|
Unix shell scripts - used with
Informix |
|
|
Program Name |
Description |
|
Report on database extents for
an online engine database (uses sysmaster) |
|
|
Report on table size and percent
populated for disk planning (uses sysmaster) |
|
|
Report on table location,
fragmentation and extents (uses sysmaster) |
|
|
Report on where the extents of a
table reside and which chunk (uses oncheck -pe) |
|
|
Resize extents or move table to
a different dbspace(uses alter fragment) |
|
|
User friendly 'onstat -d',
display chunk info in Pages, K, Megs or Bytes with totals (uses sysmaster) |
|
|
Display system locks, who has
lock, who lock is waiting for (uses sysmaster) |
|
|
Display list of databases in an
instance (uses sysmaster) |
|
|
Report on fragmentation of free
disk spaces (per chunk and total space) (uses oncheck -pe) |
|
|
Try to determine most active
Informix sessions |
|
|
Update all tables in the
database to use 'row' level locking |
|
|
Peruse transactions in the
logical log |
|
|
Report on raw disk partition
information using prtvtoc (for Sun Solaris) |
|
|
Perform a Level 0 archive in
background |
|
|
Instructions and script to use archecker
to validate an ontape archive |
|
|
Start continuous logging to tape
(in background) |
|
|
Stop continuous logging to tape |
|
|
Enable transaction logging |
|
|
Disable transaction logging |
|
|
Startup and Shutdown Informix at
boot time (Linux) |
|
|
Rotate Informix Archive file
(used when doing ontape to disk) |
|
|
Rotate Informix status log files
at boot time (online.log, messages/console.log) |
|
|
Rotate Informix logical log
backup files at boot time (used when backing up the logical log to disk) |
|
|
Warn if number of extents
exceeds a specified emergency and warning limit - intended to be run in
background |
|
|
Warn if available free space
falls below a specified emergency and warning limit - intended to be run in
background |
|
|
Warn if available free space
falls below a specified emergency and warning percent - intended to be run in
background |
|
|
Create logical, physical and
data dbspaces immediately after initializing a new Informix instance |
|
|
Move and re-size the physical
log |
|
|
Add new logical logs and put
them in the logging dbspace. Delete the 3 logs in the rootdbs. |
|
|
A script for e-mailing someone about important Informix events.
Set ONCONFIG parameter ALARMPROGRAM to point to this script. This script also
warns you if the logical logs have reached a designated percent full. |
|
|
Checks to see if you have added
any new Virtual shared memory segments |
|
|
Free up unused Informix virtual
memory segments (onmode -f) |
|
|
Bounce the Informix engine
(Bring it down, then up). |
|
|
Start or stop the ISA (Informix
Server Administrator) |
|
|
Log the number of Informix user
threads |
|
|
Count and log the number of
Informix user threads by type of connection |
|
|
Check and log access
to the database. |
|
|
|
|
|
Unix
downloads and shell
scripts - used with HP/UX |
|
|
Program Name |
Description |
|
Warn if available Unix
filesystem free space falls below a specified emergency and warning limit -
intended to be run in background. |
|
|
Warn if available Unix
filesystem free space falls below a specified emergency and warning percent -
intended to be run in background. |
|
|
Which disks are the most busy
(Uses SAR, sysmaster and vgdisplay - designed for HP-UX systems) |
|
|
Display processes not running at
the default cpu (nice) priority |
|
|
Script for removing old Unix
users in a controlled and protected way |
|
|
Startup and Shutdown Informix at
boot time (for HP-UX) |
|
|
Collect info needed to do a
HP-UX patch analysis |
|
|
Check for phantom Unix processes
on HP/UX |
|
|
Check status of HP disks |
|
|
Interrogate /etc/lvmtab
to map hardware addresses to device names on HP/UX |
|
|
Run 'make_recovery' to create a
bootable backup of /dev/vg00 using Ignite on HP/UX |
|
|
HP Ignite - used to backup
/dev/vg00 and create a bootable backup tape |
|
|
Backup Unix filesystems not in
vg00 using tar (when using Ignite to backup up vg00) |
|
|
Procedure for creating an HP/UX
mirrored boot disk |
|
|
Procedure for recovering and
restoring a crashed HP/UX mirrored boot disk |
|
|
Procedure for recovering and
restoring a crashed HP/UX mirrored non-boot disk. This includes recovering an
Informix mirrored disk as well.. |
|
|
HP/UX Logical Volume Manager
notes |
|
|
|
|
|
Unix
downloads and shell
scripts - used with SCO |
|
|
Program Name |
Description |
|
Warn if available Unix
filesystem free space falls below a specified emergency and warning limit -
intended to be run in background. |
|
|
|
|
|
File Name |
Description |
|
baker_updstat.tar.gz
(20 KB) |
Rick Baker's
multi-threaded Update Statistics Utility (with a little tweaking by yours
truly). Read the Informix
Tech Notes article that explains all about it. This is a great tool! |
|
Show when the last time update
statistics was run |
|
|
Mark Scranton's Informix
internals (Powerpoint) presentation - presented at
the Informix User Conference on 10/2000 in Orlando (998 KB) |
|
|
Troy Hewitt's
Onstat Quick Reference Guide (in MS-Word format - zipped) |
|
|
How to backup your logical logs
to disk |
|
|
IDS Informix extent sizing
spreadsheet - for helping to calcuate extent values |
|
|
|
|
|
General
OnBar
resources |
|
|
File Name |
Description |
|
The Powerpoint
presentation by John Miller and Erik van Veen of Informix Software on
Informix Backup and OnBar - delivered at the 10/2000 Informix User Conference
in Orlando |
|
|
Article by W. Curtis Preston -
Chapter 14 - Unix Backup & Recovery - O'Reilly & Associates |
|
|
by Maury Tiller |
|
|
by Maury Tiller |
|
|
|
|
|
Unix shell scripts - used with Informix, OnBar and Veritas Net Backup |
|
|
Program Name |
Description |
|
Run a level 0 backup using OnBar and Veritas. |
|
|
Run a full restore using OnBar and Veritas. |
|
|
Backup an Informix logical log
to tape whenever a log is full. |
|
|
Veritas tape availability
report. |
|
|
Veritas tape retention report. |
|
|
Veritas display the status of a
specific tape volume. |
|
|
Veritas display pending tape
mount/dismount/error requests |
|
|
Expire a tape on demand. |
|
|
Freeze a tape on demand. |
|
|
Delete a tape volume from
Veritas control. |
|
|
Enable a non-root user to run
Veritas |
|
|
|
|
|
Unix shell scripts - used with Informix, OnBar and Legato NetWorker |
|
|
Program Name |
Description |
|
Run a level 0 backup using OnBar and Legato. |
|
|
Label a tape - override Legato's default expiration period. |
|
|
|
|
|
General
purpose Unix shell
scripts |
|
|
Program Name |
Description |
|
Display Used Disk Space (Do an 'ls -l' with totals) |
|
|
Display Used Disk Space (Only
display info for sub-directories) |
|
|
Find recently added very large
files that are taking up all your Unix disk space. |
|
|
Run any program and send e-mail
of stdout (if any). This is useful for running error checking programs from
the cron where there may no output. It prevents sending a blank e-mail to the
user. |
|
|
User friendly 'df' for Data
General (DGUX) |
|
|
Test switching into 132 column
mode and back to 80 column mode. |
|
|
|
|
|
Program Name |
Description |
|
Stored Procedure Library 1 -
various stored procedures used to handle a table containing text narratives. |
|
|
|
|
|
Program Name |
Description |
|
Split a long ascii record up for printing |
|
|
Print a new-line between
level-breaks |
|
|
Cut the middle out of a file |
|
|
Insert a new line to split up
very long lines into multiple lines (This was originally intended to take someone's very long path and make it more readable) |
|
|
Misc Perl utility functions |
|
|
|
|
|
Program Name |
Description |
|
Convert comma-delimited ascii
file to pipe-delimited |
|
|
Do the equilivent of a DOS
remark statement - but cleaner |
|
|
Cut leftmost column from a file
- select number of characters to cut |
|
|
A simple menu
written in C |
|
|
Copy a file - written in C |
|
|
do a pause in DOS - written in C |
|
|
Track how long it takes to read
a file |
|
|
Count bytes, words, lines |
|
|
Look for and fix ascii files
with imbedded NULL or INVALID characters. Save bad records in an error log
file |
|
|
Count number of delimiters in a
delimited file to prepare for loading into an Informix Database |
|
|
Remove preceeding tabs and
blanks from a file |
|
|
Merge subsequent lines in a file |
|
|
|
|
|
File Name |
Description |
|
A Unix compatible compression program - source in C |
|
|
Gzip version 1.24 - Source code |
|
Hints, Tips, Tricks & FAQ's
|
File Name |
Description |
|
Informix
FAQ's |
|
|
I can login to Unix (HP/UX)
without a problem. But when I try to connect to Informix, I get an Informix
-952 error (User's password is not correct for the database server.) How can that be ? |
|
|
We are having problems running
level 0 archives. In the online.log file there were
repeated "951" SQL error msgs. The msg read: "User informix is
not known on the database server". I attempted
to run a level 0 to /dev/null and received: "database is in an unstable
state.", as an error msg. |
|
|
I need to restore an Informix
mirror (under HP/UX). |
|
|
Environmental variable AFDEBUG |
|
|
HP/UX Logical Volume Manager
notes |
|
|
Error: Cannot find message file.
Check INFORMIXDIR and DBLANG |
|
|
My Informix 4GL program core
dumps with no error message or gets SQL error -4339 whenever I execute it. |
|
|
How to remove a
Unix filename that begins with a hyphen or <escape>. |
|
|
What do those totals at the
bottom of a 'onstat -u' represent ? They don't seem to tie to anything! |
|
|
I get a very long delay (1 - 2 minutes) when I try to telnet to - or - connect to my
Informix server. But after I get connected - everything seems normal. What's up ? |
|
|
I have a bad chunk in a dbspace
that is bad and marked "down" by Informix. But I didn't
really care about the data in that chunk anyway, so I just want to drop it.
But when I try to drop the chunk using "onspaces" it says I can't because it is "down". |
|
|
I got ISAM error -142: overflow
of tblspace page. What does this mean ? |
|
|
When I run oncheck
-cr, I get the following error message: |
|
|
How to fake a backup in Informix
XPS to make newly added logical logs available |
|
|
How do I enable large chunk
sizes in Informix 9.4 ? |
|
|
Unix, Informix and Elite administration
policies and standards |