Solving Problems for our Clients since 1999.

Computer support services that keep your business in business.

If your business depends on computer systems to stay competitive,
you can depend on PRS Technologies.

Other Downloads

Attorneys may bill by the quarter hour, but information wants to be free. Check out these tips, tricks, workarounds, downloads, and cool code.

Microsoft .Net, Visual Studio and Visual Basic (VB)

Program Description
FindControl You can't do a FindControl of a BoundField

PHP - Presentation to Informix User Conference 10/25/2000 (Orlando)

Program Description
PowerPoint Presentation Beginner's Guide to Web-Enabling your Informix Database using PHP (on Linux)
Download entire Powerpoint presentation (464 KB)
Gzipped tarball of entire source code Source code of main PHP demo program used to update the videotape database (8 KB)
video_db2.php3
common.inc
menu.inc
display_form.inc
query.inc
add.inc
modify.inc
Source code of main PHP demo program used to update the videotape database
vhs.sql Schema used to create the video database table
PHP Source Code /
Run-it
Description of php example used in Powerpoint presentation
Source: php_demo1.php3
Run it: php_demo1.html
An introductory example to PHP
Source: php_demo2.php3
Run it: php_demo2.html
Switching between HTML and PHP and back
Source: php_demo3.php3
Run it: php_demo3.html
Connecting to an Informix Database
Source: php_demo4.php3
Run it: php_demo4.html
Displaying an Informix Error Message
Source: php_demo5.php3
Run it: php_demo5.html
Select a count from a table
Source: php_demo6.php3
Run it: php_demo6.html
Select rows - Output to an HTML table
Source: php_demo7.php3
Run it: php_demo7.html
Select rows using a cursor
Source: php_demo8.php3
Run it: php_demo8.html
Demonstrate variable scope - part 1
php_demo8.inc Demonstrate variable scope - part 2
Program Description
Tech Notes Informix Tech Notes article on PHP by Mario Estrada
Download the source code associated with this article (36 KB)
Cabin Reservation System Monterey Peninsula Ski Club - Cabin Reservation System, by Jonathan Leffler
Leffler's PHP Powerpoint Presentation Powerpoint presentation created by Jonathan Leffler and delivered in June 2000
PHP Manual PHP Developer Manual Online in HTML (from www.php.net)
The PHP Resource Index The PHP Resource Index
The PHP Builder Website The PHP Builder website
The PHP Website The PHP website
The PHP Crazy website The PHP Crazy website. Lots of good examples.

Perl

Note: For .perl files, right-click and save to your hard disk.

Program Description
PowerPoint Presentation Beginner's Guide to Web-Enabling your Informix Database using Perl (on NT)
pdemo1.perl Perl Demo 1
pdemo2.perl Perl Demo 2
pdemo3.perl Perl Demo 3
video_db1.perl Manage your Video Database from a web browser
vhs.sql Schema used to create the video database table
sql_runner.bat DOS batch script used to run dbaccess
PowerPoint Presentation Perl, Apache, DBI and DBD::Informix (by Jonathan Leffler) presented at the 10/2000 IUC conference in Orlando
choprec.perl Split a long ascii record up for printing
level_break.perl Print a new-line between level-breaks
middle.perl Cut the middle out of a file
splitup.perl 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)
perl_lib1.perl Misc Perl utility functions

Unix Shell Scripts used with Informix

Program Description
extent1.sh Report on database extents for an online engine database (uses sysmaster)
extent2.sh Report on table size and percent populated for disk planning (uses sysmaster)
extent3.sh Report on table location, fragmentation and extents (uses sysmaster)
table_map1.sh Report on where the extents of a table reside and which chunk (uses oncheck -pe)
reorg4.sh Resize extents or move table to a different dbspace(uses alter fragment)
uf_onstatd.sh User friendly 'onstat -d', display chunk info in Pages, K, Megs or Bytes with totals (uses sysmaster)
syslocks.sh Display system locks, who has lock, who lock is waiting for (uses sysmaster)
dblist.sh Display list of databases in an instance (uses sysmaster)
free_frag.sh Report on fragmentation of free disk spaces (per chunk and total space) (uses oncheck -pe)
most_active1.sh Try to determine most active Informix sessions
row_locking.sh Update all tables in the database to use 'row' level locking
onlog1.sh Peruse transactions in the logical log
sun_vtoc1.sh Report on raw disk partition information using prtvtoc (for Sun Solaris)
db_archive.sh Perform a Level 0 archive in background
archecker.sh Instructions and script to use archecker to validate an ontape archive
start_logging.sh Start continuous logging to tape (in background)
stop_logging.sh Stop continuous logging to tape
enable_logging.sh Enable transaction logging
disable_logging.sh Disable transaction logging
S99informix.sh Startup and Shutdown Informix at boot time (Linux)
rotate_informix_archive.sh Rotate Informix Archive file (used when doing ontape to disk)
rotate_informix_logs.sh Rotate Informix status log files at boot time (online.log, messages/console.log)
rotate_informix_logical.sh Rotate Informix logical log backup files at boot time (used when backing up the logical log to disk)
check_dbs_extents.sh Warn if number of extents exceeds a specified emergency and warning limit - intended to be run in background
Good example of the "WHILE READ" technique in shell scripts
check_dbs_free_space.sh Warn if available free space falls below a specified emergency and warning limit - intended to be run in background
Good example of the "WHILE READ" technique in shell scripts
check_dbs_free_percent.sh Warn if available free space falls below a specified emergency and warning percent - intended to be run in background
Good example of the "WHILE READ" technique in shell scripts
mk_dbspaces1.sh Create logical, physical and data dbspaces immediately after initializing a new Informix instance
move_physical.sh Move and re-size the physical log
add_logs1.sh Add new logical logs and put them in the logging dbspace. Delete the 3 logs in the rootdbs.
alarmprog1.sh 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.
check_new_segments.sh Checks to see if you have added any new Virtual shared memory segments
onmode_f.sh Free up unused Informix virtual memory segments (onmode -f)
bounce.sh Bounce the Informix engine (Bring it down, then up).
isa Start or stop the ISA (Informix Server Administrator)
log_num_threads.sh Log the number of Informix user threads
connect_type_log.sh Count and log the number of Informix user threads by type of connection
check_db_access.sh Check and log access to the database.
Good example of evaluating '-x' run-time arguments in a shell script

Unix Shell Scripts used with HP/UX

Program Description
check_unix_free_space1_hp.sh Warn if available Unix filesystem free space falls below a specified emergency and warning limit - intended to be run in background.
check_unix_free_percent1_hp.sh Warn if available Unix filesystem free space falls below a specified emergency and warning percent - intended to be run in background.
hp_busy_disk1.sh Which disks are the most busy (Uses SAR, sysmaster and vgdisplay - designed for HP-UX systems)
Good example of the "WHILE READ" technique in shell scripts
hp_not_nice.sh Display processes not running at the default cpu (nice) priority
remove_users.sh Script for removing old Unix users in a controlled and protected way
S900informix_hp.sh Startup and Shutdown Informix at boot time (for HP-UX)
cpm_collect.sh Collect info needed to do a HP-UX patch analysis
check_phantom1.pl Check for phantom Unix processes on HP/UX
ck_hp_disk_status.sh Check status of HP disks
hp_disk_table1.sh Interrogate /etc/lvmtab to map hardware addresses to device names on HP/UX
make_ignite.sh Run 'make_recovery' to create a bootable backup of /dev/vg00 using Ignite on HP/UX
non_vg00_backup.sh Backup Unix filesystems not in vg00 using tar (when using Ignite to backup up vg00)
hp_mirror_bootdisk Procedure for creating an HP/UX mirrored boot disk
hp_restore_mirrored_boot_disk Procedure for recovering and restoring a crashed HP/UX mirrored boot disk
restore_mirror1 Procedure for recovering and restoring a crashed HP/UX mirrored non-boot disk. This includes recovering an Informix mirrored disk as well..
HP/UX LVM Notes HP/UX Logical Volume Manager notes

Unix Shell Scripts used with SCO

Program Description
check_unix_free_space1_sco.sh Warn if available Unix filesystem free space falls below a specified emergency and warning limit - intended to be run in background.

Other Informix Downloads

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!
And here is another great article about Understanding and Tuning Update Statistics by John F. Miller, III
last_uptstat.sh Show when the last time update statistics was run
mark_scranton_internals.ppt Mark Scranton's Informix internals (Powerpoint) presentation - presented at the Informix User Conference on 10/2000 in Orlando (998 KB)
onstatquickref.zip Troy Hewitt's Onstat Quick Reference Guide (in MS-Word format - zipped)
logical_log_backup_to_disk How to backup your logical logs to disk
informix_sizing.xls IDS Informix extent sizing spreadsheet - for helping to calcuate extent values

General OnBar Resources

File name Description
Informix Backups and OnBar 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
Informix Backup & Recovery Article by W. Curtis Preston - Chapter 14 - Unix Backup & Recovery - O'Reilly & Associates
Onbar Overview by Maury Tiller
Onbar Performance Tools by Maury Tiller

Unix Shell Scripts used with Informix, OnBar and Veritas Net Backup

Program Description
onbar_full_backup.sh Run a level 0 backup using OnBar and Veritas.
onbar_full_restore.sh Run a full restore using OnBar and Veritas.
log_full.sh Backup an Informix logical log to tape whenever a log is full.
tape_nbu_list_media.sh Veritas tape availability report.
tape_nbu_retention_rpt.sh Veritas tape retention report.
tape_nbu_query_status.sh Veritas display the status of a specific tape volume.
tape_nbu_pending.sh Veritas display pending tape mount/dismount/error requests
tape_nbu_expire.sh Expire a tape on demand.
tape_nbu_freeze_media.sh Freeze a tape on demand.
tape_nbu_delete.sh Delete a tape volume from Veritas control.
tape_nbu_convert_to_non_root.sh Enable a non-root user to run Veritas

Unix Shell Scripts used with Informix, OnBar and Legato NetWorker

Program Description
onbar_full_backup.sh Run a level 0 backup using OnBar and Legato.
label_tape.sh Label a tape - override Legato's default expiration period.

General Purpose Unix Shell Scripts

Program Description
du.sh Display Used Disk Space (Do an 'ls -l' with totals)
du_dir.sh Display Used Disk Space (Only display info for sub-directories)
find_recent_large_files.sh Find recently added very large files that are taking up all your Unix disk space.
mail_any_output.sh 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.
uf_df_dg.sh User friendly 'df' for Data General (DGUX)
132test.sh Test switching into 132 column mode and back to 80 column mode.

Stored Procedures

Program Description
spl_lib1.spl Stored Procedure Library 1 - various stored procedures used to handle a table containing text narratives.

C

Program Description
comma2pipe.c Convert comma-delimited ascii file to pipe-delimited
comment.c Do the equilivent of a DOS remark statement - but cleaner
cutleft.c Cut leftmost column from a file - select number of characters to cut
menu.c A simple menu written in C
mycopy.c Copy a file - written in C
pausec.c do a pause in DOS - written in C
timetest.c Track how long it takes to read a file
wc.c Count bytes, words, lines
fixnull1.c Look for and fix ascii files with imbedded NULL or INVALID characters. Save bad records in an error log file
cntdelim.c Count number of delimiters in a delimited file to prepare for loading into an Informix Database
rm_preceeding.c Remove preceeding tabs and blanks from a file
mergelines.c Merge subsequent lines in a file

Hints, Tips & Tricks

File name Description
Informix FAQ's
Error -952 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 ?
Error -951 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.
Restore a mirrored disk I need to restore an Informix mirror (under HP/UX).
AFDEBUG Environmental variable AFDEBUG
HP/UX LVM Notes HP/UX Logical Volume Manager notes
The rule of TEN Error: Cannot find message file. Check INFORMIXDIR and DBLANG
Informix 4GL program cores dumps My Informix 4GL program core dumps with no error message or gets SQL error -4339 whenever I execute it.
Hyphen or <escape> in filename How to remove a Unix filename that begins with a hyphen or <escape>.
Totals in onstat -u What do those totals at the bottom of a 'onstat -u' represent ? They don't seem to tie to anything!
Connection Delay 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 want to drop a bad chunk 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".
ISAM error -142 I got ISAM error -142: overflow of tblspace page. What does this mean ?
oncheck -cr When I run oncheck -cr, I get the following error message:
I/O open() chunk 1, pagenum 0, pagecnt 12 --> errno = 13
XPS Fake Backup How to fake a backup in Informix XPS to make newly added logical logs available
Large chunk sizes How do I enable large chunk sizes in Informix 9.4 ?
Standards Unix, Informix and Elite administration policies and standards

Miscellaneous

File name Description
compress.zip A Unix compatible compression program - source in C
gzip124.zip Gzip version 1.24 - Source code

NTR Installable RC Client for Windows.msi
NTR Inquiero Installable RC (Remote Control) Client for Windows