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 |