May 1995 Newsletter

Volume 5, No. 2

Highlights of This Issue

MARC ANDREESSEN, CO-FOUNDER OF NETSCAPE, TO KEYNOTE INFORMIX WORLDWIDE USER CONFERENCE

Informix Online 5.X TB Utilities Quick Reference Guide

Next Meeting - Implementing Informix Network Solutions

Date and Time: June 20th, 1995 9:00 a.m. - 12:00 noon

Location: Informix Software Corporation

8065 Leesburg Pike, Suite 600, Vienna, VA 22182

Phone: 703-847-2900

NOTE: This is the New Federal Division Offices across from Tysons Corner Mall

Registration Fee Discounts for User Group Members

for the Informix Worldwide User Conference

"The Informix Worldwide User Conference and Exposition will be held at the San Jose Convention Center in San Jose, California from July 17-20, 1995. The conference offers a unique opportunity to meet with Informix, and our customers, partners, and professional colleagues. Our goal is to share as much information as you want and need about our products, programs, services, and strategic direction. The following are some special offers we are extending to User Group members:

Discounted conference pricing at $495.00 for Conference-only registration and $595.00 for Conference and Tutorial registration (a value worth $1090.00). And as a bonus for attending, you will receive a free copy of INFORMIX-NewEra ViewPoint Pro for Windows (a $1,000.00 value).

A special track session will be offered highlighting Informix User Groups and their future plans.

A private reception for User Group Members.

An Informix User Group booth will be set up in the Exhibit Hall to promote User Groups around the world.

"If you have an interest in information systems for client/server, relational database technology, and/or Informix products and services, the conference is sure to be a wise investment of your time. You can register by calling 1-800-926-EXPO, or via the World Wide Web address http://www.informix.com/."

Annual Special Edition of Newsletter

We will be producing a special edition of our newsletter for the Informix Worldwide User Conference in July. Last year 2,000 copies of a special 24 page edition were distributed to our local members, Worldwide Conference attendees, and new members as they joined the user group. This year we are planning a bigger issue. We have some exciting new articles planned. If you would be interested in contributing an article, please contact Lester Knutsen as space is limited.

Sponsors for the Newsletter Special Edition

We already have three companies committed to sponsoring the Special Edition newsletter. We are looking for three more companies who would be willing to share the costs of this special edition. Each sponsor will have one page for information or advertising. If you are interested, please call Lester Knutsen, at 703-256-0267.

Plans for 1995

Elections to the Board of Directors

User Group Membership

New Address

Press Release

4th Annual Conference To Be Held At San Jose Convention Center, July 17-20

MENLO PARK, Calif. (Jan. 31, 1995) -- Informix Software, Inc., (NASDAQ: IFMX) the leading provider of parallel processing database technology, today announced that 23-year old Marc Andreessen, vice president of technology and co-founder of Netscape Communications Corporation and co-developer of the NCSA Mosaic* browser for the World Wide Web, will deliver the opening keynote address at the 1995 Informix Worldwide User Conference. Andreessen was honored in Microtimes as "Man of the Year" in 1994 and in Time Magazine's list of the 50 most promising Americans under age 40.

This year's conference and exhibition entitled "Maximize Your Performance" will be held July 17-20 at the San Jose McEnery Convention Center in San Jose, California. Andreessen will open the conference by discussing the World Wide Web and its ability to maximize business' performance by understanding and exploiting opportunities on the information highway. Informix recently launched its site on the World Wide Web which provides users with easy access to a variety of information on Informix products, services, partners and customers.

The conference will feature more than 80 conference sessions, tutorials, and other breakouts designed to help Informix's customers and partners effectively use Informix database technology to be more competitive. The conference will also feature a 75,000 square foot exhibition hall where over 100 Informix, customers, hardware and software partners, and VARs will showcase Informix-based solutions. Demonstrations of Informix's latest parallel database servers and tool products will be featured at the Informix booth during the exhibition.

New In 1995

The fourth annual conference will feature half-day industry-specific sessions given by Informix's Industry Marketing group and customers to highlight Informix's strategy and success in specific industries. A panel of industry leaders will discuss future issues facing specific industry segments.

End users will be able to meet with members of Informix's consulting organization to ask specific questions regarding Informix products or services.

A Multi-Media Center will feature information on Informix's products and services in a number of media forms: World Wide Web, CD Rom, interactive kiosks, video and print.

The conference will also feature a roundtable discussion on the latest trends in the database industry with leading industry analysts.

"Informix has taken an industry-leading position in the database market with its advanced technology and record-breaking customer benchmark results," said Phil White, chairman and CEO of Informix. "This year's focus is to show our customer and partners how they can maximize their performance into the next century, using the most powerful and best architected database technologies."

Conference Program

Attendees will be able to choose from six conference tracks: Industry Solutions; Tools and Environments; Applications; Servers and Connectivity; Business Management; and Advanced Technology. Conference sessions, led by Informix's top technical marketing and development personnel, as well as consultants and integrators, are designed to help attendees understand how to take advantage of Informix technology as they look ahead to their future computing needs.

More information about the conference is available by contacting (800) 926-EXPO in the U.S., (310) 459-4600 outside the U.S., or online at http://www.informix.com.

Informix Online 5.X TB Utilities Quick Reference Guide

TBCHECK
Usage:  tbcheck [-clist] [-plist] [-qny]
                [ { database[:[owner.]table] | TBLSpace number | Chunk number}
                  { rowid | page number } ]
-c      - check
    r   - reserved pages
    e   - TBLSpace extents and chunk extents
    c   - database catalogs
    i   - table indexes
    I   - table indexes and rowids in index
    d   - TBLSpace data rows including bitmaps
    D   - TBLSpace data rows including bitmaps, remainder pages and blobs
-p      - print
    r   - reserved pages (-cr)
    e   - extents report (-ce)
    c   - catalog report (-cc)
    k   - keys in index (-ci)
    K   - keys and rowids in index (-cI)
    l   - leaf node keys only (-ci)
    L   - leaf node keys and rowids (-cI)
    d   - TBLSpace data rows (-cd)
    D   - TBLSpace data rows including bitmaps, remainder pages and blobs(-cD)
    t   - TBLSpace report
    T   - TBLSpace disk utilization report
    p   - dump page for the given [table and rowid | TBLSpace and page number]
    P   - dump page for the given chunk number and page number
    B   - BLOBSpace utilization for given table(s) [database:[owner.]]table
-q      - quiet mode - print only error messages
-n      - answer NO to all questions
-y      - answer YES to all questions


TBINIT
Usage:  tbinit [-i] [-p] [-s] [-y]
	-i	disk space initialization
	-p	do not delete temp tables during shared memory initialization
	-s	stay in quiescent mode
	-y	answer YES to all prompts


TBLOAD
Usage: tbload [-l] [-m] [-t <tape device>] [-b <block size>] [-s <tape size>]
		[-d <dbspace>] <database>[:[<owner>.]<table>]
		[{-i <old index name> <new index name>}]


TBLOG
Usage:  tblog [-l] [-q] [-b] [-d <tape device>] [-n <log file number>]
	      [-u <user name>] [-t <tblspace number>] [-x <transaction number>]
	-l   display maximum information about each log record
	-q   do not display program header
	-b   display information about logged BLOB pages (-d option only)
	-d   read from tape device
	-n   display the specified log(s)
	-u   display the specified user(s)
	-t   display the specified tblspace(s)
	-x   display the specified transaction(s)


TBMIRROR
Usage: tbmirror  -a -d spacename -p pathname -o offset  -mp mirror-path -mo mirror-offset  
 	-r -d spacename 
 	-l -d spacename  
 	-m -d spacename -p pathname -o offset 


TBMODE Usage:  tbmode -csmkunrz
      -c         do checkpoint
      -s         shutdown to single user
      -m         go to multi-user on-line
      -k         shutdown completely
      -u         shutdown and kill all attached processes
      -n         set shared memory non-resident
      -r         set shared memory resident
      -z pid     kill specified process id
      -Z address heuristically complete specified transaction
      -l         force to next logical log
      -y         do not require confirmation


TBPARAMS
Usage:  tbparams  { -a -d dbspace | -d -l logid [-y] |
                    -p -s size [-d dbspace] [-y] }
    -a  - add a logical log
    -d  - drop a logical log
    -p  - change physical log size and location


TBSPACES
Usage:
 tbspaces  { -a spacename -p pathname -o offset -s size [-m path offset]  |
             -c {-d dbspace | -b blobspace -g pagesize}
                     -p pathname -o offset -s size [-m path offset] |
             -d spacename [-y] |
             -s spacename -p pathname -o offset {-O | -D} [-y] }
    -a - add a chunk to a dbspace or blobspace
    -c - create a dbspace or blobspace
    -d - drop a dbspace or blobspace
    -s - change the status of a chunk


TBSTAT
Usage:  tbstat [-abcdklmpstuzBDFPRX] [-r seconds] [-o file] [infile]
    -a     print all info (options: bcdklmpstu)
    -b     print buffers
    -c     print configuration file
    -d     print dbspaces and chunks
    -k     print locks
    -l     print logging
    -m     print message log
    -p     print profile
    -s     print latches
    -t     print tblspaces
    -u     print users
    -z     zero profile counts
    -B     print all buffers
    -D     print dbspaces and detailed chunk stats
    -F     print page flushers
    -P     print profile, including BIGreads
    -R     print LRU queues
    -X     print entire list of sharers and waiters for buffers
    -r     repeat options every n seconds (default: 5)
    -o     put shared memory into specified file (default: tbstat.out)
    infile use infile to obtain shared memory information
     -C     print security session configuration.


TBTAPE
Usage:  tbtape { [-s] | [-c] | [-a] | [-r] |
                  [-N database ...] [-U database ...] [-B database ...] }
     -s   Archive all dbspaces/BLOBSpaces.
     -c   Continuous backup of logical logs.
     -a   Automatic backup of logical logs.
     -r   Restore entire INFORMIX-OnLine/Secure sytem.
     -N   Set the following database(s) to no logging.
     -U   Set the following database(s) to unbuffered logging.
     -B   Set the following database(s) to buffered logging.
     - Turning on logging for a database must be combined with -s option.


TBUNLOAD
Usage: tbunload [-l] [-t <tape device>] [-b <block size>] [-s <tape size>]
		<database>[:[<owner>.]<table>]

Lester B. Knutsen

Advanced DataTools Corporation

4216 Evergreen Lane, Suite 136

Annandale, VA 22003