[go: up one dir, main page]
Scribd
Upload
21 views2 pages

Instance Creation

Uploaded by

Syed Hassnain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
21 views2 pages

Instance Creation

Uploaded by

Syed Hassnain
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

INFORMIX INSTANCE CREATION:

add port in etc/services


ids121port 34551/tcp # {prt for IDS121 instance
Switch to informix userid
[root@rhel1 storage]# su - informix
[informix@rhel1 ~]$ cd /mnt/storage
[informix@rhel1 storage]$ touch rootdbs.1 online.log
[informix@rhel1 storage]$ ls -ltr
total 0
-rw-rw-r--. 1 informix informix 0 Oct 16 10:55 rootdbs.1
-rw-rw-r--. 1 informix informix 0 Oct 16 10:55 online.log
[informix@rhel1 storage]$ chmod 660 rootdbs.1 online.log

[informix@rhel1 storage]$ vi env.ids141


[informix@rhel1 storage]$ pwd
/mnt/storage
[informix@rhel1 storage]$ cat env.ids141
export INFORMIXDIR=/mnt/IDS1410 ##environment variable where the product is
installed.
export INFORMIXSERVER=ids141 ## what is INFORMIX SERVER instance name
basically
export ONCONFIG=onconfig.ids141 ## where is configuration file
(parameter file)
export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts ## this file have the server
name port etc define
export PATH=$INFORMIXDIR/bin:$PATH
export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$LD_LIBRARY_PATH
export TERM=vt100 ## Terminal settings.
export TERMCAP=$INFORMIXDIR/etc/termcap ## Terminal settings.

. ./env.ids12
[informix@db1 storage]$ onstat - ## this command tells me informix server status
shared memory not initialized for INFORMIXSERVER 'ids141' (meaning that the
instance is down)

[informix@rhel1 storage]$ cd $INFORMIXDIR


[informix@rhel1 IDS121]$ cd etc
[informix@rhel1 etc]$ cp onconfig.std onconfig.ids141
[informix@rhel1 etc]$ vi onconfig.ids141 (and modify below configuration
parameters)
ROOTPATH /mnt/storage/rootdbs.1 #The path for the device containing the root
chunk
MSGPATH /mnt/storage/online.log
TAPEDEV /dev/null
LTAPEDEV /dev/null
DBSERVERNAME ids141 ## YOUR INSTANCE NAME
LOGFILE 12

[informix@rhel1 etc]$ cp sqlhosts.std sqlhosts


[informix@rhel1 etc]$ vi sqlhosts and add below line at the bottom of file
instance || protocol || hostname || instance port
ids141 onsoctcp db1.db.com ids141port

++++++++++++++++++++++++++++++
STEP5: Initialize instance
++++++++++++++++++++++++++++++

[informix@rhel1 etc]$ cd /mnt/storage


[informix@rhel1 storage]$ ls -ltr
total 4
-rw-r----- 1 informix informix 0 Oct 16 10:55 rootdbs.1
-rw-rw-r-- 1 informix informix 0 Oct 16 10:55 online.log
-rw-r--r-- 1 informix informix 296 Oct 16 10:58 env.ids12
[informix@rhel1 storage]$ . ./env.ids12
Your evaluation license will expire on 2017-01-14 00:00:00
shared memory not initialized for INFORMIXSERVER 'ids121'

[informix@rhel1 storage]$ oninit -ivy ## this will start your instance


[informix@db1 storage]$ oninit -ivy
Warning: The IBM Informix Dynamic Server Developer Edition license restriction
limits
the total shared memory size for this server to 16777216 KB. The
maximum allowable shared memory will be set to this size. (SHMTOTAL)
Reading configuration file '/mnt/IDS121/etc/onconfig.ids121'...succeeded
Creating /INFORMIXTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 4310 kbytes...succeeded
Creating infos file "/mnt/IDS121/etc/.infos.ids121"...succeeded
Linking conf file "/mnt/IDS121/etc/.conf.ids121"...succeeded
Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (2656K)... Writing
to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Initializing encryption-at-rest if necessary...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 8 flushers...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Creating database partition...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Creating VP cache drain thread...succeeded
Creating limits manager thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5
################ MODE 5 MEANS YOUR INSTANCE IS CREATED
#################################

You might also like