bash- 2 . 03 $ cat /etc/hosts
#
# Internet host table
#
 127 . 0 . 0 . 1        localhost       
 192 . 168 . 12 . 1     omcrsys1        omcrsys1.localdomain omc_splat omc_4gl omc_pm loghost
 192 . 168 . 12 . 20   omcrgui1
bash- 2 . 03 $

bash- 2 . 03 $ cat /etc/services
#ident  "@(#)services   1.27    00/11/06 SMI"   /* SVr4.0 1.8   */
#
#
# Copyright (c)  1999 - 2000  by Sun Microsystems, Inc.
# All rights reserved.
#
# Network services, Internet style
#
tcpmux           1 /tcp
echo             7 /tcp
echo             7 /udp
discard          9 /tcp           sink null
discard          9 /udp           sink null
systat           11 /tcp          users
daytime          13 /tcp
daytime          13 /udp
netstat          15 /tcp
chargen          19 /tcp          ttytst source
chargen          19 /udp          ttytst source
ftp-data         20 /tcp
ftp              21 /tcp
telnet           23 /tcp
smtp             25 /tcp          mail
time             37 /tcp          timserver
time             37 /udp          timserver
name             42 /udp          nameserver
whois            43 /tcp          nicname         # usually to sri-nic
domain           53 /udp
domain           53 /tcp
bootps           67 /udp                          # BOOTP/DHCP server
bootpc           68 /udp                          # BOOTP/DHCP client
hostnames        101 /tcp         hostname        # usually to sri-nic
pop2             109 /tcp         pop- 2            # Post Office Protocol - V2
pop3             110 /tcp                         # Post Office Protocol - Version  3 
sunrpc           111 /udp         rpcbind
sunrpc           111 /tcp         rpcbind
imap             143 /tcp         imap2           # Internet Mail Access Protocol v2
ldap             389 /tcp                         # Lightweight Directory Access Protocol 
ldap             389 /udp                         # Lightweight Directory Access Protocol
submission       587 /tcp                         # Mail Message Submission
submission       587 /udp                         #    see RFC  2476 
ldaps            636 /tcp                         # LDAP protocol over TLS/SSL (was sldap)
ldaps            636 /udp                         # LDAP protocol over TLS/SSL (was sldap)
#
# Host specific functions
#
tftp             69 /udp
rje              77 /tcp
finger           79 /tcp
link             87 /tcp          ttylink
supdup           95 /tcp
iso-tsap         102 /tcp
x400             103 /tcp                         # ISO Mail
x400-snd         104 /tcp
csnet-ns         105 /tcp
pop- 2             109 /tcp                         # Post Office
uucp-path        117 /tcp
nntp             119 /tcp         usenet          # Network News Transfer
ntp              123 /tcp                         # Network Time Protocol
ntp              123 /udp                         # Network Time Protocol
netbios-ns       137 /tcp                         # NETBIOS Name Service
netbios-ns       137 /udp                         # NETBIOS Name Service
netbios-dgm      138 /tcp                         # NETBIOS Datagram Service
netbios-dgm      138 /udp                         # NETBIOS Datagram Service
netbios-ssn      139 /tcp                         # NETBIOS Session Service
netbios-ssn      139 /udp                         # NETBIOS Session Service
NeWS             144 /tcp         news            # Window System
slp              427 /tcp         slp             # Service Location Protocol, V2
slp              427 /udp         slp             # Service Location Protocol, V2
mobile-ip        434 /udp         mobile-ip       # Mobile-IP
cvc_hostd        442 /tcp                         # Network Console
#
# UNIX specific services
#
# these are NOT officially assigned
#
exec             512 /tcp
login            513 /tcp
shell            514 /tcp         cmd             # no passwords used
printer          515 /tcp         spooler         # line printer spooler
courier          530 /tcp         rpc             # experimental
uucp             540 /tcp         uucpd           # uucp daemon
biff             512 /udp         comsat
who              513 /udp         whod
syslog           514 /udp
talk             517 /udp
route            520 /udp         router routed
ripng            521 /udp
klogin           543 /tcp                         # Kerberos authenticated rlogin
kshell           544 /tcp         cmd             # Kerberos authenticated remote shell
new-rwho         550 /udp         new-who         # experimental
rmonitor         560 /udp         rmonitord       # experimental
monitor          561 /udp                         # experimental
pcserver         600 /tcp                         # ECD Integrated PC board srvr
sun-dr           665 /tcp                         # Remote Dynamic Reconfiguration
kerberos-adm     749 /tcp                         # Kerberos V5 Administration
kerberos-adm     749 /udp                         # Kerberos V5 Administration
kerberos         750 /udp         kdc             # Kerberos key server
kerberos         750 /tcp         kdc             # Kerberos key server
krb5_prop        754 /tcp                         # Kerberos V5 KDC propogation
ufsd             1008 /tcp        ufsd            # UFS-aware server
ufsd             1008 /udp        ufsd
cvc              1495 /tcp                        # Network Console
ingreslock       1524 /tcp
www-ldap-gw      1760 /tcp                        # HTTP to LDAP gateway
www-ldap-gw      1760 /udp                        # HTTP to LDAP gateway
listen           2766 /tcp                        # System V listener port
nfsd             2049 /udp        nfs             # NFS server daemon (clts)
nfsd             2049 /tcp        nfs             # NFS server daemon (cots)
eklogin          2105 /tcp                        # Kerberos encrypted rlogin
lockd            4045 /udp                        # NFS lock daemon/manager
lockd            4045 /tcp
dtspc            6112 /tcp                        # CDE subprocess control
fs               7100 /tcp                        # Font server
inf7_OMC_serv  5000 /tcp             # OMC database Informix DSA instance
inf7_MIB_serv  5010 /tcp             # MIB database Informix DSA instance
mcOMC  5030 /tcp             # Multiple Connect - OMC PR138598
mcMIB  5040 /tcp             # Multiple Connect - MIB PR138598
axnet            5492 /tcp
bash- 2 . 03 $

bash- 2 . 03 $ find / -name sqlhosts
/usr/informix/etc/sqlhosts
/usr/omc/ 1 . 7 . 6 . 0 .e/config/sqlhosts
bash- 2 . 03 $

bash- 2 . 03 $ cat /usr/informix/etc/sqlhosts
demo_on onipcshm        on_hostname     on_servername
demo_se seipcpip        se_hostname     sqlexec
bash- 2 . 03 $

bash- 2 . 03 $ cat /usr/omc/ 1 . 7 . 6 . 0 .e/config/sqlhosts
omc_sys1        onipcshm        omc_sys         Inf7_serv1
omc_sys         ontlitcp        omc_sys         Inf7_serv
bash- 2 . 03 $

inf7_OMC_serv  5000 /tcp             # OMC database Informix DSA instance
inf7_MIB_serv  5010 /tcp             # MIB database Informix DSA instance
mcOMC  5030 /tcp             # Multiple Connect - OMC PR138598
mcMIB  5040 /tcp             # Multiple Connect - MIB PR138598

#!/bin/sh
################################################################################
### This file sources in the correct environment under the bourne shell.  This 
### is done centrally here so that the tools can be run under ANY login name, 
### not just names that have the default shell set specifically to the "C" shell 
### or the Bourne shell.  Also, all of the tools can call it so that if/when the 
### database/release changes a change is needed here and nowhere else.
################################################################################

################################################################################
### This environment is for the PM DATABASE
################################################################################

. /usr/omc/config/global/pmInfxUserConfig.sh

isql omc_db

bash- 2 . 03 $ cat /usr/omc/config/global/pmInfxUserConfig.sh
# ######################
# @(#)pmInfxUserConfig.sh.S      1 . 1  Copyright  1997 , Motorola Inc.
#
# Description:
#
#  Environment variables that need to be set for the any users performing
#  operations on the PM database to configure access to the Informix 
#  database engine.
#
# Restrictions:
#
#  this file should only contain valid export commands
#  and/or comments.  The variable and export command 
#  should be on seperate lines. 
#
#
#  29 / 11 / 2001  David Hollingworth Added LRUAGE to address Informix  7 . 31  issue
#
#  20 / 05 / 2003  David Hollingworth Added ONCONFIG variable.

INFORMIXDIR=/usr/informix
export INFORMIXDIR
INFORMIXSQLHOSTS=${INFORMIXDIR}/etc/sqlhosts_OMC
export INFORMIXSQLHOSTS
INFORMIXSERVER=omc_sys1
export INFORMIXSERVER
INFORMIXSHMBASE= 1024000 
export INFORMIXSHMBASE
PATH=${PATH}:${INFORMIXDIR}/bin
export PATH
DBPATH=//omc_mib
export DBPATH
DBDATE=dmy4/
export DBDATE
LRUAGE= 1 
export LRUAGE # Addresses LRU queue aging problem in Informix  7 . 31 
ONCONFIG=onconfig_OMC
export ONCONFIG
bash- 2 . 03 $ 

bash- 2 . 03 $ cat /usr/informix/etc/sqlhosts_OMC 

omc_sys1        onipcshm        omc_splat       60k_OMC_shm
omc_sys         ontlitcp        omc_splat       inf7_OMC_serv
omc_mib         ontlitcp        omc_splat       inf7_MIB_serv

mcOMC192168012001 ontlitcp      omcrsys1        mcOMC
bash- 2 . 03 $

bash- 2 . 03 $ cat /usr/informix/etc/onconfig_OMC
#**************************************************************************
#
#                          INFORMIX SOFTWARE, INC.
#
#  Title:       onconfig.std
#  Description: INFORMIX-OnLine Configuration Parameters
#
#**************************************************************************

# Root Dbspace Configuration

ROOTNAME        rootdbs         # Root dbspace name
ROOTPATH        /dev/omc_db_root  # Path for device containing root dbspace
ROOTOFFSET       4                # Offset of root dbspace into device (Kbytes)
ROOTSIZE      2047996  # Size of root dbspace (Kbytes) 

# Disk Mirroring Configuration Parameters

MIRROR           1                # Mirroring flag (Yes =  1 , No =  0 )
MIRRORPATH                      # Path for device containing mirrored root
MIRROROFFSET     0                # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS         rootdbs         # Location (dbspace) of physical log
PHYSFILE         2000             # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES         6                # Number of logical log files
LOGSIZE          2000             # Logical log size (Kbytes)

# Do not use fuzzy checkpoints.
NOFUZZYCKPT      1                # No fuzzy checkpoints

# Diagnostics 

MSGPATH         /usr/informix/online.log_OMC # System message log file path
CONSOLE         /usr/informix/online.log_OMC    # System console message path
ALARMPROGRAM                    # Alarm program path

# System Archive Tape Device

TAPEDEV         /dev/rmt/ 0       # Tape device path      
TAPEBLK          1024             # Tape block size (Kbytes)
TAPESIZE         4000000          # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV        /dev/null       # Log tape device path
LTAPEBLK         16               # Log tape block size (Kbytes)
LTAPESIZE        10240            # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB                       # INFORMIX-OnLine/Optical staging area 

# System Configuration

SERVERNUM        2                # Unique id corresponding to a OnLine instance
DBSERVERNAME    omc_sys1        # Name of default database server
DBSERVERALIASES omc_sys,mcOMC192168012001               # List of alternate dbservernames
NETTYPE         ipcshm, 1 , 80 ,CPU # Override sqlhosts nettype parameters
NETTYPE         tlitcp, 1 , 80 ,NET # Override sqlhosts nettype parameters
DEADLOCK_TIMEOUT         60       # Max time to wait of lock in distributed env.
RESIDENT         0                # Forced residency flag (Yes =  1 , No =  0 )

MULTIPROCESSOR   1                #  0  for single-processor,  1  for multi-processor
NUMCPUVPS        2                # Number of user (cpu) vps
SINGLE_CPU_VP    0                # If non-zero, limit number of cpu vps to one

NOAGE            1                # Process aging
AFF_SPROC        0                # Affinity start processor
AFF_NPROCS       0                # Affinity number of processors

# Shared Memory Parameters

LOCKS            75000            # Maximum number of locks
BUFFERS          50000            # Maximum number of shared buffers
NUMAIOVPS        1                # Number of IO vps
PHYSBUFF         128              # Physical log buffer size (Kbytes)
LOGBUFF          128              # Logical log buffer size (Kbytes)
LOGSMAX          50               # Maximum number of logical log files
CLEANERS         6                # Number of buffer cleaner processes
SHMBASE         0x0A000000L     # Shared memory base address
SHMVIRTSIZE      32000            # initial virtual shared memory segment size
SHMADD           8192             # Size of new shared memory segments (Kbytes)
SHMTOTAL         0                # Total shared memory (Kbytes).  0 =>unlimited
CKPTINTVL        300              # Check point interval (in sec)
LRUS             15               # Number of LRU queues
LRU_MAX_DIRTY    2                # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY    1                # LRU percent dirty end cleaning limit
LTXHWM           50               # Long transaction high water mark percentage
LTXEHWM          60               # Long transaction high water mark (exclusive)
TXTIMEOUT        300              # Transaction timeout (in sec)
STACKSIZE        32               # Stack size (Kbytes)

# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
#            To determine the page size used by OnLine on your platform
#            see the last line of output from the command, 'onstat -b'.


# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS       10       # Default number of offline worker threads
ON_RECVRY_THREADS        1        # Default number of online worker threads

# Data Replication Variables
# DRAUTO:  0  manual,  1  retain type,  2  reverse type
DRAUTO           0                # DR automatic switchover
DRINTERVAL       30               # DR max time between DR buffer flushes (in sec)
DRTIMEOUT        30               # DR network timeout (in sec)
DRLOSTFOUND     /dev/null       # DR lost+found file path

# Read Ahead Variables
RA_PAGES         32               # Number of pages to attempt to read ahead
RA_THRESHOLD     28               # Number of pages left before next group

# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online.  If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP     omc_db_temp             # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs 
# during OnLine operations.  
# For DUMPSHMEM, DUMPGCORE and DUMPCORE  1  means Yes,  0  means No.

DUMPDIR         /usr/tmp                # Preserve diagnostics in this directory
DUMPSHMEM        1                # Dump a copy of shared memory
DUMPGCORE        0                # Dump a core image using 'gcore'
DUMPCORE         0                # Dump a core image (Warning:this aborts OnLine)
DUMPCNT          1                # Number of shared memory or gcore dumps for 
                                # a single user's session

# ADT*
# The following parameters control the type and level of secure auditing
# present in the OnLine system. By default, ADTMODE is  0  and auditing
# is disabled

ADTMODE          0        # Auditing mode
ADTPATH         /tmp    # Directory where audit trails will be written by OnLine
ADTSIZE          50000    # Maximum size of any single audit trail file
ADTERR           0        #  0  ==> retry failed audit writes;  1  ==> log failure

FILLFACTOR       90               # Fill factor for building indexes

# method for OnLine to use when determining current time
USEOSTIME        0        #  0 : use internal time(fast),  1 : get time from OS(slow)

# Parallel Database Queries (pdq)
PDQPRIORITY      0       # Degree of parallelism:  0  ...  100 ,
                       #                        OFF =>  0 , LOW =>  1 , HIGH =>  100 
MAX_PDQPRIORITY  100     # Maximum allowed pdqpriority
DS_MAX_QUERIES   2       # Maximum number of decision support queries 
DS_TOTAL_MEMORY  10000   # Decision support memory (Kbytes) 
DS_MAX_SCANS     10      # Maximum number of decision support scans       
DATASKIP        off    # List of dbspaces to skip

# OPTCOMPIND
#  0  => Nested loop joins will be preferred (where 
#      possible) over sortmerge joins and hash joins. 
#  1  => If the transaction isolation mode is not  
#      "repeatable read", optimizer behaves as in ( 2 ) 
#      below.  Otherwise it behaves as in ( 0 ) above. 
#  2  => Use costs regardless of the transaction isolation
#      mode.  Nested loop joins are not necessarily  
#      preferred.  Optimizer bases its decision purely  
#      on costs. 
OPTCOMPIND       2       # To hint the optimizer

ONDBSPACEDOWN    0       # Dbspace down option:  0  = CONTINUE,  1  = ABORT,  2  = WAIT
LBU_PRESERVE     1       # Preserve last log for log backup 
OPCACHEMAX       0       # Maximum optical cache size (Kbytes)

# Backup/Restore variables
BAR_ACT_LOG   /usr/informix/bar_act.log  # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /usr/informix/bar_dbug.log # ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP   0 
BAR_RETRY        1 
BAR_NB_XPORT_COUNT  10 
BAR_XFER_BUF_SIZE  31 
RESTARTABLE_RESTORE     OFF
BAR_PROGRESS_FREQ        0 

TBLSPACE_STATS   1                # Maintain tblspace statistics
CDR_EVALTHREADS  1 , 2              # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT   5                # DS lockwait timeout (seconds)
CDR_QUEUEMEM     4096             # Maximum amount of memory for any CDR queue (Kbytes)
CDR_LOGDELTA     30               # % of log space allowed in queue memory
CDR_NUMCONNECT   16               # Expected connections per server
CDR_NIFRETRY     300              # Connection retry (seconds)
CDR_NIFCOMPRESS  0                # Link level compression (- 1  never,  0  none,  9  max)
ISM_DATA_POOL   ISMData         
ISM_LOG_POOL    ISMLogs         
DIRECTIVES       1                # Optimizer DIRECTIVES ON ( 1 /Default) or OFF ( 0 ) 
HETERO_COMMIT    0                
SBSPACENAME                     # Default smartblob space name - this is where blobs
SYSSBSPACENAME                  # Default smartblob space for use by the Informix 
BLOCKTIMEOUT     3600             # Default timeout for system block
SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
OPT_GOAL        - 1               
ALLOW_NEWLINE    0                # embedded newlines(Yes =  1 , No =  0  or anything but  1 )
JVPJAVAHOME                     # JRE installation root directory
JVPHOME                         # Krakatoa installation directory
JVPPROPFILE     .jvpprops       # JVP property file
JVPLOGFILE      jvp.log         # JVP log file.
JDKVERSION                      # JDK version supported by this server
JVMTHREAD       green           # Java VM thread type (green or native)
JVPJAVALIB                      
JVPJAVAVM       libjava.so      
JVPCLASSPATH                    
bash- 2 . 03 $ 

olsoctcp;onsoctcp;olsocspx;onsocspx;sesoctcp;sesocspx;seipcpip;olipcnmp;onipcnmp