Peter Schmidt's Download Page

PHP Source Code	Run-it	Description of php example used in Powerpoint presentation
php_demo1.php3	php_demo1.html	An introductory example to PHP
php_demo2.php3	php_demo2.html	Switching between HTML and PHP and back
php_demo3.php3	php_demo3.html	Connecting to an Informix Database
php_demo4.php3	php_demo4.html	Displaying an Informix Error Message
php_demo5.php3	php_demo5.html	Select a count from a table
php_demo6.php3	php_demo6.html	Select rows - Output to an HTML table
php_demo7.php3	php_demo7.html	Select rows using a cursor
php_demo8.php3	php_demo8.html	Demonstrate variable scope - part 1
php_demo8.inc		Demonstrate variable scope - part 2

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 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 Presentation to Informix International Users Conference (Solutions Portal) 7/20/1999 (San Diego)
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

Downloads

Unix shell scripts - used with Informix
Program Name	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 downloads and shell scripts - used with HP/UX
Program Name	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
ignite10_all.tar	HP Ignite - used to backup /dev/vg00 and create a bootable backup tape
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 downloads and shell scripts - used with SCO
Program Name	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 Name	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 Name	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 Name	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 Name	Description
spl_lib1.spl	Stored Procedure Library 1 - various stored procedures used to handle a table containing text narratives.
Perl
Program Name	Description
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
C
Program Name	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
Miscellaneous
File Name	Description
compress.zip	A Unix compatible compression program - source in C
gzip124.zip	Gzip version 1.24 - Source code

Hints, Tips, Tricks & FAQ's

File Name	Description
Informix FAQ's	Made available from the folks at www.smooth1.demon.co.uk From the Mark Scranton I*Teach Site From June Tong Tuning Informix Dynamic Server and Your System for Optimum Performance - From Art Kagel
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