Restore and network down problem
I loaded informix and did a restore of the ontape backup (ontape -r).
but I get the
error of networkdown after the restore was done.
When I restored I did not recreate the database I only created the
chunks and dbspaces. Did i do something wrong here? here are the
results and settings I have. What do I need to do.
Informix Dynamic Server Version 7.31.UC5
sqlhosts
ok_srvr onipcshm rp4440 ipcs0000
ok_tcp onsoctcp rp4440 srvr0001
services
srvr0001 8001/tcp #Informix port
onconfig
SERVERNUM 1 # Unique id corresponding to a DynamicServer in
stance
DBSERVERNAME ok_srvr # Name of default database server
DBSERVERALIASES ok_tcp # List of alternate dbservernames
NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,1,5,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env.
RESIDENT -1 # Forced residency flag (Yes = 1, No =
0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor
NUMCPUVPS 2 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one
# Shared Memory Parameters
LOCKS 500000 # Maximum number of locks
BUFFERS 200000 # Maximum number of shared buffers
NUMAIOVPS 8 # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)LOGSMAX 100 # Maximum number of logical log files
CLEANERS 127 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
SHMVIRTSIZE 300000 # initial virtual shared memory segment
size
SHMADD 40000 # Size of new shared memory segments
(Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes).
0=>unlimited
CKPTINTVL 360 # Check point interval (in sec)
KENNEL PARAMETERS HP UX 11.11
maxuprc 75
maxusers 700
nfile 14369
semmni 4096
semmns 4096
semmnu 1024
semmsl 2048
shmem 1
shmmax 805306368
shmmni 512
shmseg 256
onmonitor
Dynamic Server: Status Parameters DbspacesMode Force-Ckpt ...
Status menu to view Dynamic Server.
** WARNING: Network Down **--On-Line------- Press CTRL-W for Help.
--------
# onstat -m16:38:24 Event alarms enabled. ALARMPROG =
'/u/informix/etc/log_full.sh'
16:38:24 Could not disable priority aging: errno = 1
16:38:29 DR: DRAUTO is 0 (Off)
16:38:29 Requested shared memory segment size rounded from 4188KB to4192KB
16:38:30 Informix Dynamic Server Version 7.31.UC5 Software SerialNumber AAC
#J876311
16:38:30 Informix Dynamic Server Initialized -- Shared MemoryInitialized.
16:38:30 Physical Recovery Started.
16:38:30 Physical Recovery Complete: 0 Pages Restored.
16:38:30 Logical Recovery Started.
16:38:32 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
16:38:33 Dataskip is now OFF for all dbspaces
16:38:33 On-Line Mode
16:38:33 Checkpoint Completed: duration was 0 seconds.
# onstat -d
Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 00:14:19
-- 752608
Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
8004e158 1 1 1 1 N informix rootdbs
8099ff58 2 1 2 20 N informix datadbs
809ccd38 3 1 6 15 N informix dbspace1
809ccdf8 4 1 9 12 N informix datadbs2
809cceb8 5 1 12 1 N informix logdbs
809ccf78 6 2001 13 1 N T informix tempdbs
6 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
8004e218 1 1 0 500000 372749 PO- /dev/rootdbs
8099e198 2 2 0 1000000 85 PO-
/dev/datadbsi
8099e278 3 2 0 1000000 79 PO-
/dev/datadbsh
8099e358 4 2 0 1000000 66 PO-
/dev/datadbsj
8099e438 5 2 0 1000000 795 PO-
/dev/datadbsk
8099e518 6 3 0 1000000 16384 PO-
/dev/datadbsc
8099e5f8 7 3 0 1000000 0 PO-
/dev/datadbsd
8099e6d8 8 3 0 1000000 11000 PO-
/dev/datadbsf
8099e7b8 9 4 0 1000000 8 PO-
/dev/datadbsa
8099e898 10 4 0 1000000 0 PO-
/dev/datadbsb
8099e978 11 4 0 750000 3774 PO-
/dev/datadbse
8099ea58 12 5 750001 250000 174947 PO-
/dev/datadbse
8099eb38 13 6 0 250000 249947 PO- /dev/tempdbs
8099ec18 14 4 0 500000 0 PO-
/dev/datadbsg
8099ecf8 15 2 0 340000 512 PO-
/dev/datadbsl
8099edd8 16 2 0 500000 1104 PO-
/dev/datadbsm
8099eeb8 17 2 340001 680000 418 PO-
/dev/datadbsl
8099ef98 18 2 500001 520000 52 PO-
/dev/datadbsm
8099f078 19 3 0 1000000 0 PO-
/dev/datadbsn
8099f158 20 4 0 1000000 3000 PO-
/dev/datadbso
8099f238 21 2 0 1000000 77 PO-
/dev/datadbsp
8099f318 22 2 0 1000000 514 PO-
/dev/datadbsq
8099f3f8 23 3 0 1000000 1000 PO-
/dev/datadbsr
8099f4d8 24 4 0 1000000 0 PO-
/dev/datadbss
8099f5b8 25 2 0 500000 0 PO-
/dev/datadbst
8099f698 26 3 0 500000 0 PO-
/dev/datadbsu
8099f778 27 4 0 500000 0 PO-
/dev/datadbsv
8099f858 28 2 0 1000000 693 PO-
/dev/datadbsw
8099f938 29 2 500001 500000 1488 PO-
/dev/datadbst
8099fa18 30 4 500001 500000 0 PO-
/dev/datadbsu
8099faf8 31 2 500001 500000 9976 PO-
/dev/datadbsg
8099fbd8 32 2 0 1000000 24400 PO-
/dev/okdatadbs1
8099fcb8 33 3 0 1000000 0 PO-
/dev/okdatadbs2
8099fd98 34 4 0 1000000 3 PO-
/dev/okdatadbs3
8099fe78 35 2 0 1000000 100000 PO-
/dev/okdatadbs4
809cc018 36 2 0 1000000 146149 PO-
/dev/okdatadbs5
809cc0f8 37 4 0 1000000 0 PO-
/dev/okdatadbs6
809cc1d8 38 3 0 1000000 0 PO-
/dev/okdatadbs7
809cc2b8 39 2 0 1000000 51700 PO-
/dev/okdatadbs8
809cc398 40 3 0 1000000 0 PO-
/dev/okdatadbs9
809cc478 41 3 0 1000000 0
Try dbaccess -->> choose qry language
it looks like you got stuf back (onstat -d)
the network down looks/sounds like/could be a config error;
what is the hostname??
could also be a bug???
first try dbaccess;
if you really need to get the 'network down error' to be gone
shut the database,
try to kick out shared mem connections
modify:
> DBSERVERNAME ok_srvr # Name of default database serverto
DBSERVERNAME ok_tcp
kick out:
> DBSERVERALIASES ok_tcp # List of alternate dbservernames
> NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype
modify:
> ok_tcp onsoctcp rp4440 srvr0001to
ok_tcp onsoctcp <ipadress hostname><somefreenumber maybe value of srvr0001>
start the db.
debug from there ...
Superboer.
mchivaviro@okzim.co.zw schreef:
> I loaded informix and did a restore of the ontape backup (ontape -r).
> but I get the
> error of networkdown after the restore was done.
> When I restored I did not recreate the database I only created the
> chunks and dbspaces. Did i do something wrong here? here are the
> results and settings I have. What do I need to do.
>
> Informix Dynamic Server Version 7.31.UC5
> sqlhosts
> ok_srvr onipcshm rp4440 ipcs0000
> ok_tcp onsoctcp rp4440 srvr0001>
>
> services
> srvr0001 8001/tcp #Informix port
>
>
> onconfig
> SERVERNUM 1 # Unique id corresponding to a Dynamic> Server in
> stance
> DBSERVERNAME ok_srvr # Name of default database server
> DBSERVERALIASES ok_tcp # List of alternate dbservernames
> NETTYPE ipcshm,1,400,CPU # Configure poll thread(s) for nettype
>
> NETTYPE soctcp,1,5,NET # Configure poll thread(s) for nettype
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> distributed env.
> RESIDENT -1 # 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
>
>
> # Shared Memory Parameters
>
>
> LOCKS 500000 # Maximum number of locks
> BUFFERS 200000 # Maximum number of shared buffers
> NUMAIOVPS 8 # Number of IO vps
> PHYSBUFF 128 # Physical log buffer size (Kbytes)
> LOGBUFF 128 # Logical log buffer size (Kbytes)> LOGSMAX 100 # Maximum number of logical log files
> CLEANERS 127 # Number of buffer cleaner processes
> SHMBASE 0x0 # Shared memory base address
> SHMVIRTSIZE 300000 # initial virtual shared memory segment>
> size
> SHMADD 40000 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes).
> 0=>unlimited
> CKPTINTVL 360 # Check point interval (in sec)>
>
> KENNEL PARAMETERS HP UX 11.11
> maxuprc 75
>
>
> maxusers 700
> nfile 14369
> semmni 4096
>
>
> semmns 4096
>
>
> semmnu 1024
> semmsl 2048
> shmem 1
>
>
> shmmax 805306368
>
>
> shmmni 512
> shmseg 256
>
>
> onmonitor
> Dynamic Server: Status Parameters DbspacesMode Force-Ckpt ...
> Status menu to view Dynamic Server.
>
>
> ** WARNING: Network Down **--On-Line------- Press CTRL-W for Help.
> --------
>
>
> # onstat -m> 16:38:24 Event alarms enabled. ALARMPROG =
> '/u/informix/etc/log_full.sh'
> 16:38:24 Could not disable priority aging: errno = 1
> 16:38:29 DR: DRAUTO is 0 (Off)
> 16:38:29 Requested shared memory segment size rounded from 4188KB to> 4192KB
> 16:38:30 Informix Dynamic Server Version 7.31.UC5 Software Serial> Number AAC
> #J876311
> 16:38:30 Informix Dynamic Server Initialized -- Shared Memory> Initialized.
> 16:38:30 Physical Recovery Started.
> 16:38:30 Physical Recovery Complete: 0 Pages Restored.
> 16:38:30 Logical Recovery Started.
> 16:38:32 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
>
>
> 16:38:33 Dataskip is now OFF for all dbspaces
> 16:38:33 On-Line Mode
> 16:38:33 Checkpoint Completed: duration was 0 seconds.>
>
> # onstat -d>
>
> Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 00:14:19
> -- 752608
> Kbytes
>
>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 8004e158 1 1 1 1 N informix rootdbs
> 8099ff58 2 1 2 20 N informix datadbs
> 809ccd38 3 1 6 15 N informix dbspace1
>
> 809ccdf8 4 1 9 12 N informix datadbs2
>
> 809cceb8 5 1 12 1 N informix logdbs
> 809ccf78 6 2001 13 1 N T informix tempdbs
> 6 active, 2047 maximum
>
>
> Chunks
> address chk/dbs offset size free bpages flags pathname
> 8004e218 1 1 0 500000 372749 PO- /dev/rootdbs
>
> 8099e198 2 2 0 1000000 85 PO-
> /dev/datadbsi
> 8099e278 3 2 0 1000000 79 PO-
> /dev/datadbsh
> 8099e358 4 2 0 1000000 66 PO-
> /dev/datadbsj
> 8099e438 5 2 0 1000000 795 PO-
> /dev/datadbsk
> 8099e518 6 3 0 1000000 16384 PO-
> /dev/datadbsc
> 8099e5f8 7 3 0 1000000 0 PO-
> /dev/datadbsd
> 8099e6d8 8 3 0 1000000 11000 PO-
> /dev/datadbsf
> 8099e7b8 9 4 0 1000000 8 PO-
> /dev/datadbsa
> 8099e898 10 4 0 1000000 0 PO-
> /dev/datadbsb
> 8099e978 11 4 0 750000 3774 PO-
> /dev/datadbse
> 8099ea58 12 5 750001 250000 174947 PO-
> /dev/datadbse
> 8099eb38 13 6 0 250000 249947 PO- /dev/tempdbs
>
> 8099ec18 14 4 0 500000 0 PO-
> /dev/datadbsg
> 8099ecf8 15 2 0 340000 512 PO-
> /dev/datadbsl
> 8099edd8 16 2 0 500000 1104 PO-
> /dev/datadbsm
> 8099eeb8 17 2 340001 680000 418 PO-
> /dev/datadbsl
> 8099ef98 18 2 500001 520000 52 PO-
> /dev/datadbsm
> 8099f078 19 3 0 1000000 0 PO-
> /dev/datadbsn
> 8099f158 20 4 0 1000000 3000 PO-
> /dev/datadbso
> 8099f238 21 2 0 1000000 77 PO-
> /dev/datadbsp
> 8099f318 22 2 0 1000000 514 PO-
> /dev/datadbsq
> 8099f3f8 23 3 0 1000000 1000 PO-@@