Losing dbspaces/chunks after server shutdown
A user on IDS 10.00.UC4 / AIX 5.3 found that all dbspaces and chunks created with onspaces vanished after each shutdown and restart, leaving only rootdbs. Replies identified the cause immediately: he was restarting with 'oninit -iy', where -i reinitializes all disk structures (wiping the instance) and -y auto-confirms. The fix is to use plain 'oninit' (or 'oninit -v'/'-y') for normal startup, reserving -i for first-time initialization; the lost spaces must be recreated or restored from the ontape level-0 archive.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Good day all,
My problem has to do with the IDS 10 server I am currently running on an IBM
pServer p505 and AIX 5.3.
My true setup is IDS 10.00.UC4 on AIX 5.3 rel 5:
# dbaccess V --> DB-Access Version 10.00.UC4
# oslevel -r --> 5300-05
My problem occurs in the following manner:
1. I setup my dbspaces as needed; following are the onspaces commands
that I run:
* onspaces -c -d regular_dbs1 -p /dev/lon_vilshe_dev_02 -o 0 -s
1048576
* onspaces -c -d hi_use_dbs1 -p /dev/lon_vilshe_dev_03 -o 0 -s 1048576
* onspaces -c -d data_whse1 -p /dev/lon_vilshe_dev_04 -o 0 -s 2097152
* onspaces -c -d tmp_dbs1 -p /dev/lon_vilshe_dev_t01 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs2 -p /dev/lon_vilshe_dev_t02 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs3 -p /dev/lon_vilshe_dev_t03 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs4 -p /dev/lon_vilshe_dev_t04 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs5 -p /dev/lon_vilshe_dev_t05 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs6 -p /dev/lon_vilshe_dev_t06 -o 0 -s 102400 t
2. Running the onstat d command at this point shows that the newly
created dbspaces/chunks are all present and created as required.
# onstat -d
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 01:20:33
-- 72368 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner
name
4012a7e8 1 0x60001 1 1 4096 N B informix
rootdbs
5032b1d0 2 0x60001 2 1 4096 N B informix
regular_dbs1
5032b8a0 3 0x60001 3 1 4096 N B informix
hi_use_dbs1
50332018 4 0x60001 4 1 4096 N B informix
data_whse1
50332678 5 0x42001 5 1 4096 N TB informix
tmp_dbs1
50332de0 6 0x42001 6 1 4096 N TB informix
tmp_dbs2
50333578 7 0x42001 7 1 4096 N TB informix
tmp_dbs3
50333d10 8 0x42001 8 1 4096 N TB informix
tmp_dbs4
503344a8 9 0x42001 9 1 4096 N TB informix
tmp_dbs5
50334c40 10 0x42001 10 1 4096 N TB informix
tmp_dbs6
10 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags
pathname
4012a948 1 1 0 20480 10340 PO-B
/dev/lon_vilshe_dev_01
5032b330 2 2 0 262144 262091 PO-B
/dev/lon_vilshe_dev_02
5032ba00 3 3 0 262144 262091 PO-B
/dev/lon_vilshe_dev_03
50332178 4 4 0 524288 524235 PO-B
/dev/lon_vilshe_dev_04
503327d8 5 5 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t01
50332f40 6 6 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t02
503336d8 7 7 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t03
50333e70 8 8 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t04
50334608 9 9 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t05
50334da0 10 10 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t06
10 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always
3. I run ontape s L 0 (to get a level 0 backup)
# ontape -s -L 0
Archive to tape device '/dev/null' is complete.
Program over.
4. I shutdown the server using the onmode ky command.
5. I restart the server with the oninit iy command
# oninit -iy
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
with this Server instance, please make sure that your SHMBASE value
specifies in onconfig is 0x40000000L or above. Otherwise you will have
problems while attaching or dynamically adding virtual shared memory
segments. Please refer to Server machine notes for more information.
6. Running the onstat d command at this point shows that the newly
created dbspaces/chunks have all disappeared.
# onstat -d
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:00:11
-- 72368 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner
name
4012a7e8 1 0x41001 1 1 4096 N B informix
rootdbs
1 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags
pathname
4012a948 1 1 0 20480 11384 PO-B
/dev/lon_vilshe_dev_01
1 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always
I have redone this series of tasks several times now and I am VERY annoyed
with what is happening (losing all my dbspaces everytime).
Has anyone come across this kind of problem and/or would anyone be aware of
any reason why IDS would be trashing my dbspaces in this manner?
Please note that no error message is logged in the error message file
(MSGPATH).
Hope someone can help me get rid of this annoying situation.
Best regards,
Daniel Dansereau
Systèmes LogikInfo Inc.
<mailto:daniel.dansereau@logikinfo.com> daniel.dansereau@logikinfo.com
Cell: (514) 262-3166
Tel: (514) 426-4886
Fax: (514) 426-0499
Its the the iy that is doing it, check the manual
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend IDUG 2007 San Jose, North America
May 6-10, 2006
Visit http://www.iiug.org/conf for more information.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of Daniel Dansereau
> Sent: 05 November 2006 17:17
> To: ids@iiug.org
> Subject: Losing dbspaces/chunks after server shutdown [7725]
>
>
> Good day all,
>
> My problem has to do with the IDS 10 server I am currently
> running on an IBM pServer p505 and AIX 5.3.
>
> My true setup is IDS 10.00.UC4 on AIX 5.3 rel 5:
>
> # dbaccess V --> DB-Access Version 10.00.UC4>
> # oslevel -r --> 5300-05
>
> My problem occurs in the following manner:
>
> 1. I setup my dbspaces as needed; following are the onspaces
> commands that I run:
>
> * onspaces -c -d regular_dbs1 -p /dev/lon_vilshe_dev_02 -o 0 -s
> 1048576
> * onspaces -c -d hi_use_dbs1 -p /dev/lon_vilshe_dev_03 -o 0 -s 1048576
> * onspaces -c -d data_whse1 -p /dev/lon_vilshe_dev_04 -o 0 -s 2097152
> * onspaces -c -d tmp_dbs1 -p /dev/lon_vilshe_dev_t01 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs2 -p /dev/lon_vilshe_dev_t02 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs3 -p /dev/lon_vilshe_dev_t03 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs4 -p /dev/lon_vilshe_dev_t04 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs5 -p /dev/lon_vilshe_dev_t05 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs6 -p /dev/lon_vilshe_dev_t06 -o 0 -s
> 102400 t
>
> 2. Running the onstat d command at this point shows that the
> newly created dbspaces/chunks are all present and created as
> required.
>
> # onstat -d>
> IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
> Up 01:20:33
> -- 72368 Kbytes>
> Dbspaces
>
> address number flags fchunk nchunks pgsize flags owner name
>
> 4012a7e8 1 0x60001 1 1 4096 N B informix rootdbs
>
> 5032b1d0 2 0x60001 2 1 4096 N B informix
> regular_dbs1
>
> 5032b8a0 3 0x60001 3 1 4096 N B informix
> hi_use_dbs1
>
> 50332018 4 0x60001 4 1 4096 N B informix
> data_whse1
>
> 50332678 5 0x42001 5 1 4096 N TB informix
> tmp_dbs1
>
> 50332de0 6 0x42001 6 1 4096 N TB informix
> tmp_dbs2
>
> 50333578 7 0x42001 7 1 4096 N TB informix
> tmp_dbs3
>
> 50333d10 8 0x42001 8 1 4096 N TB informix
> tmp_dbs4
>
> 503344a8 9 0x42001 9 1 4096 N TB informix
> tmp_dbs5
>
> 50334c40 10 0x42001 10 1 4096 N TB informix
> tmp_dbs6
>
> 10 active, 2047 maximum
>
> Chunks
>
> address chunk/dbs offset size free bpages flags pathname
>
> 4012a948 1 1 0 20480 10340 PO-B
> /dev/lon_vilshe_dev_01
>
> 5032b330 2 2 0 262144 262091 PO-B
> /dev/lon_vilshe_dev_02
>
> 5032ba00 3 3 0 262144 262091 PO-B
> /dev/lon_vilshe_dev_03
>
> 50332178 4 4 0 524288 524235 PO-B
> /dev/lon_vilshe_dev_04
>
> 503327d8 5 5 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t01
>
> 50332f40 6 6 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t02
>
> 503336d8 7 7 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t03
>
> 50333e70 8 8 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t04
>
> 50334608 9 9 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t05
>
> 50334da0 10 10 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t06
>
> 10 active, 32766 maximum
>
> NOTE: The values in the "size" and "free" columns for DBspace
> chunks are
>
> displayed in terms of "pgsize" of the DBspace to which they belong.
>
> Expanded chunk capacity mode: always
>
> 3. I run ontape s L 0 (to get a level 0 backup)
>
> # ontape -s -L 0>
> Archive to tape device '/dev/null' is complete.
>
> Program over.
>
> 4. I shutdown the server using the onmode ky command.
>
> 5. I restart the server with the oninit iy command
>
> # oninit -iy>
> WARNING : If you intend to use J/Foundation or GLS for
> Unicode feature(GLU) with this Server instance, please make
> sure that your SHMBASE value specifies in onconfig is
> 0x40000000L or above. Otherwise you will have problems while
> attaching or dynamically adding virtual shared memory
> segments. Please refer to Server machine notes for more information.
>
> 6. Running the onstat d command at this point shows that the
> newly created dbspaces/chunks have all disappeared.
>
> # onstat -d>
> IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
> Up 00:00:11
> -- 72368 Kbytes>
> Dbspaces
>
> address number flags fchunk nchunks pgsize flags owner name
>
> 4012a7e8 1 0x41001 1 1 4096 N B informix rootdbs
>
> 1 active, 2047 maximum
>
> Chunks
>
> address chunk/dbs offset size free bpages flags pathname
>
> 4012a948 1 1 0 20480 11384 PO-B
> /dev/lon_vilshe_dev_01
>
> 1 active, 32766 maximum
>
> NOTE: The values in the "size" and "free" columns for DBspace
> chunks are
>
> displayed in terms of "pgsize" of the DBspace to which they belong.
>
> Expanded chunk capacity mode: always
>
> I have redone this series of tasks several times now and I am
> VERY annoyed with what is happening (losing all my dbspaces
> everytime).
>
> Has anyone come across this kind of problem and/or would
> anyone be aware of any reason why IDS would be trashing my
> dbspaces in this manner?
>
> Please note that no error message is logged in the error
> message file (MSGPATH).
>
> Hope someone can help me get rid of this annoying situation.
>
> Best regards,
>
> Daniel Dansereau
>
> Systèmes LogikInfo Inc.
>
> <mailto:daniel.dansereau@logikinfo.com>
> daniel.dansereau@logikinfo.com
>
> Cell: (514) 262-3166
>
> Tel: (514) 426-4886
>
> Fax: (514) 426-0499
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
oninit -iy restart your Informix instance, you will have to create dbspacesagain and recover DB information from your last backup or dbexport.
-i means initialize
-y yes to all questions
Paul Watson <paul@oninit.com> wrote:
Its the the iy that is doing it, check the manual
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend IDUG 2007 San Jose, North America
May 6-10, 2006
Visit http://www.iiug.org/conf for more information.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of Daniel Dansereau
> Sent: 05 November 2006 17:17
> To: ids@iiug.org
> Subject: Losing dbspaces/chunks after server shutdown [7725]
>
>
> Good day all,
>
> My problem has to do with the IDS 10 server I am currently
> running on an IBM pServer p505 and AIX 5.3.
>
> My true setup is IDS 10.00.UC4 on AIX 5.3 rel 5:
>
> # dbaccess V --> DB-Access Version 10.00.UC4>
> # oslevel -r --> 5300-05
>
> My problem occurs in the following manner:
>
> 1. I setup my dbspaces as needed; following are the onspaces
> commands that I run:
>
> * onspaces -c -d regular_dbs1 -p /dev/lon_vilshe_dev_02 -o 0 -s
> 1048576
> * onspaces -c -d hi_use_dbs1 -p /dev/lon_vilshe_dev_03 -o 0 -s 1048576
> * onspaces -c -d data_whse1 -p /dev/lon_vilshe_dev_04 -o 0 -s 2097152
> * onspaces -c -d tmp_dbs1 -p /dev/lon_vilshe_dev_t01 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs2 -p /dev/lon_vilshe_dev_t02 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs3 -p /dev/lon_vilshe_dev_t03 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs4 -p /dev/lon_vilshe_dev_t04 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs5 -p /dev/lon_vilshe_dev_t05 -o 0 -s 102400 -t
> * onspaces -c -d tmp_dbs6 -p /dev/lon_vilshe_dev_t06 -o 0 -s
> 102400 t
>
> 2. Running the onstat d command at this point shows that the
> newly created dbspaces/chunks are all present and created as
> required.
>
> # onstat -d>
> IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
> Up 01:20:33
> -- 72368 Kbytes>
> Dbspaces
>
> address number flags fchunk nchunks pgsize flags owner name
>
> 4012a7e8 1 0x60001 1 1 4096 N B informix rootdbs
>
> 5032b1d0 2 0x60001 2 1 4096 N B informix
> regular_dbs1
>
> 5032b8a0 3 0x60001 3 1 4096 N B informix
> hi_use_dbs1
>
> 50332018 4 0x60001 4 1 4096 N B informix
> data_whse1
>
> 50332678 5 0x42001 5 1 4096 N TB informix
> tmp_dbs1
>
> 50332de0 6 0x42001 6 1 4096 N TB informix
> tmp_dbs2
>
> 50333578 7 0x42001 7 1 4096 N TB informix
> tmp_dbs3
>
> 50333d10 8 0x42001 8 1 4096 N TB informix
> tmp_dbs4
>
> 503344a8 9 0x42001 9 1 4096 N TB informix
> tmp_dbs5
>
> 50334c40 10 0x42001 10 1 4096 N TB informix
> tmp_dbs6
>
> 10 active, 2047 maximum
>
> Chunks
>
> address chunk/dbs offset size free bpages flags pathname
>
> 4012a948 1 1 0 20480 10340 PO-B
> /dev/lon_vilshe_dev_01
>
> 5032b330 2 2 0 262144 262091 PO-B
> /dev/lon_vilshe_dev_02
>
> 5032ba00 3 3 0 262144 262091 PO-B
> /dev/lon_vilshe_dev_03
>
> 50332178 4 4 0 524288 524235 PO-B
> /dev/lon_vilshe_dev_04
>
> 503327d8 5 5 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t01
>
> 50332f40 6 6 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t02
>
> 503336d8 7 7 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t03
>
> 50333e70 8 8 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t04
>
> 50334608 9 9 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t05
>
> 50334da0 10 10 0 25600 25547 PO-B
> /dev/lon_vilshe_dev_t06
>
> 10 active, 32766 maximum
>
> NOTE: The values in the "size" and "free" columns for DBspace
> chunks are
>
> displayed in terms of "pgsize" of the DBspace to which they belong.
>
> Expanded chunk capacity mode: always
>
> 3. I run ontape s L 0 (to get a level 0 backup)
>
> # ontape -s -L 0>
> Archive to tape device '/dev/null' is complete.
>
> Program over.
>
> 4. I shutdown the server using the onmode ky command.
>
> 5. I restart the server with the oninit iy command
>
> # oninit -iy>
> WARNING : If you intend to use J/Foundation or GLS for
> Unicode feature(GLU) with this Server instance, please make
> sure that your SHMBASE value specifies in onconfig is
> 0x40000000L or above. Otherwise you will have problems while
> attaching or dynamically adding virtual shared memory
> segments. Please refer to Server machine notes for more information.
>
> 6. Running the onstat d command at this point shows that the
> newly created dbspaces/chunks have all disappeared.
>
> # onstat -d>
> IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
> Up 00:00:11
> -- 72368 Kbytes>
> Dbspaces
>
> address number flags fchunk nchunks pgsize flags owner name
>
> 4012a7e8 1 0x41001 1 1 4096 N B informix rootdbs
>
> 1 active, 2047 maximum
>
> Chunks
>
> address chunk/dbs offset size free bpages flags pathname
>
> 4012a948 1 1 0 20480 11384 PO-B
> /dev/lon_vilshe_dev_01
>
> 1 active, 32766 maximum
>
> NOTE: The values in the "size" and "free" columns for DBspace
> chunks are
>
> displayed in terms of "pgsize" of the DBspace to which they belong.
>
> Expanded chunk capacity mode: always
>
> I have redone this series of tasks several times now and I am
> VERY annoyed with what is happening (losing all my dbspaces
> everytime).
>
> Has anyone come across this kind of problem and/or would
> anyone be aware of any reason why IDS would be trashing my
> dbspaces in this manner?
>
> Please note that no error message is logged in the error
> message file (MSGPATH).
>
> Hope someone can help me get rid of this annoying situation.
>
> Best regards,
>
> Daniel Dansereau
>
> Systèmes LogikInfo Inc.
>
>
> daniel.dansereau@logikinfo.com
>
> Cell: (514) 262-3166
>
> Tel: (514) 426-4886
>
> Fax: (514) 426-0499
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
---------------------------------
Low, Low, Low Rates! Check out Yahoo! Messenger's cheap PC-to-Phone call rates.
Sonia Guerra wrote:
> oninit -iy restart your Informix instance, you will have to create dbspaces> again and recover DB information from your last backup or dbexport.
>
> -i means initialize
> -y yes to all questions
>
> Paul Watson <paul@oninit.com> wrote:
>
> Its the the iy that is doing it, check the manual
>
> Paul Watson
> Tel: +44 1414161772
> Mob: +44 7818003457
> Web: www.oninit.com
>
> GO FURTHER with DB2
> GET THERE FASTER with Informix.
> Attend IDUG 2007 San Jose, North America
> May 6-10, 2006
> Visit http://www.iiug.org/conf for more information.
>
>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
>> Behalf Of Daniel Dansereau
>> Sent: 05 November 2006 17:17
>> To: ids@iiug.org
>> Subject: Losing dbspaces/chunks after server shutdown [7725]
>>
>>
>> Good day all,
>>
>> My problem has to do with the IDS 10 server I am currently
>> running on an IBM pServer p505 and AIX 5.3.
>>
>> My true setup is IDS 10.00.UC4 on AIX 5.3 rel 5:
>>
>> # dbaccess V --> DB-Access Version 10.00.UC4>>
>> # oslevel -r --> 5300-05
>>
>> My problem occurs in the following manner:
>>
>> 1. I setup my dbspaces as needed; following are the onspaces
>> commands that I run:
>>
>> * onspaces -c -d regular_dbs1 -p /dev/lon_vilshe_dev_02 -o 0 -s
>> 1048576
>> * onspaces -c -d hi_use_dbs1 -p /dev/lon_vilshe_dev_03 -o 0 -s 1048576
>> * onspaces -c -d data_whse1 -p /dev/lon_vilshe_dev_04 -o 0 -s 2097152
>> * onspaces -c -d tmp_dbs1 -p /dev/lon_vilshe_dev_t01 -o 0 -s 102400 -t
>> * onspaces -c -d tmp_dbs2 -p /dev/lon_vilshe_dev_t02 -o 0 -s 102400 -t
>> * onspaces -c -d tmp_dbs3 -p /dev/lon_vilshe_dev_t03 -o 0 -s 102400 -t
>> * onspaces -c -d tmp_dbs4 -p /dev/lon_vilshe_dev_t04 -o 0 -s 102400 -t
>> * onspaces -c -d tmp_dbs5 -p /dev/lon_vilshe_dev_t05 -o 0 -s 102400 -t
>> * onspaces -c -d tmp_dbs6 -p /dev/lon_vilshe_dev_t06 -o 0 -s
>> 102400 t
>>
>> 2. Running the onstat d command at this point shows that the
>> newly created dbspaces/chunks are all present and created as
>> required.
>>
>> # onstat -d>>
>> IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
>> Up 01:20:33
>> -- 72368 Kbytes>>
>> Dbspaces
>>
>> address number flags fchunk nchunks pgsize flags owner name
>>
>> 4012a7e8 1 0x60001 1 1 4096 N B informix rootdbs
>>
>> 5032b1d0 2 0x60001 2 1 4096 N B informix
>> regular_dbs1
>>
>> 5032b8a0 3 0x60001 3 1 4096 N B informix
>> hi_use_dbs1
>>
>> 50332018 4 0x60001 4 1 4096 N B informix
>> data_whse1
>>
>> 50332678 5 0x42001 5 1 4096 N TB informix
>> tmp_dbs1
>>
>> 50332de0 6 0x42001 6 1 4096 N TB informix
>> tmp_dbs2
>>
>> 50333578 7 0x42001 7 1 4096 N TB informix
>> tmp_dbs3
>>
>> 50333d10 8 0x42001 8 1 4096 N TB informix
>> tmp_dbs4
>>
>> 503344a8 9 0x42001 9 1 4096 N TB informix
>> tmp_dbs5
>>
>> 50334c40 10 0x42001 10 1 4096 N TB informix
>> tmp_dbs6
>>
>> 10 active, 2047 maximum
>>
>> Chunks
>>
>> address chunk/dbs offset size free bpages flags pathname
>>
>> 4012a948 1 1 0 20480 10340 PO-B
>> /dev/lon_vilshe_dev_01
>>
>> 5032b330 2 2 0 262144 262091 PO-B
>> /dev/lon_vilshe_dev_02
>>
>> 5032ba00 3 3 0 262144 262091 PO-B
>> /dev/lon_vilshe_dev_03
>>
>> 50332178 4 4 0 524288 524235 PO-B
>> /dev/lon_vilshe_dev_04
>>
>> 503327d8 5 5 0 25600 25547 PO-B
>> /dev/lon_vilshe_dev_t01
>>
>> 50332f40 6 6 0 25600 25547 PO-B
>> /dev/lon_vilshe_dev_t02
>>
>> 503336d8 7 7 0 25600 25547 PO-B
>> /dev/lon_vilshe_dev_t03
>>
>> 50333e70 8 8 0 25600 25547 PO-B
>> /dev/lon_vilshe_dev_t04
>>
>> 50334608 9 9 0 25600 25547 PO-B
>> /dev/lon_vilshe_dev_t05
>>
>> 50334da0 10 10 0 25600 25547 PO-B
>> /dev/lon_vilshe_dev_t06
>>
>> 10 active, 32766 maximum
>>
>> NOTE: The values in the "size" and "free" columns for DBspace
>> chunks are
>>
>> displayed in terms of "pgsize" of the DBspace to which they belong.
>>
>> Expanded chunk capacity mode: always
>>
>> 3. I run ontape s L 0 (to get a level 0 backup)
>>
>> # ontape -s -L 0>>
>> Archive to tape device '/dev/null' is complete.
>>
>> Program over.
>>
>> 4. I shutdown the server using the onmode ky command.
>>
>> 5. I restart the server with the oninit iy command
>>
>> # oninit -iy>>
>> WARNING : If you intend to use J/Foundation or GLS for
>> Unicode feature(GLU) with this Server instance, please make
>> sure that your SHMBASE value specifies in onconfig is
>> 0x40000000L or above. Otherwise you will have problems while
>> attaching or dynamically adding virtual shared memory
>> segments. Please refer to Server machine notes for more information.
>>
>> 6. Running the onstat d command at this point shows that the
>> newly created dbspaces/chunks have all disappeared.
>>
>> # onstat -d>>
>> IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
>> Up 00:00:11
>> -- 72368 Kbytes>>
>> Dbspaces
>>
>> address number flags fchunk nchunks pgsize flags owner name
>>
>> 4012a7e8 1 0x41001 1 1 4096 N B informix rootdbs
>>
>> 1 active, 2047 maximum
>>
>> Chunks
>>
>> address chunk/dbs offset size free bpages flags pathname
>>
>> 4012a948 1 1 0 20480 11384 PO-B
>> /dev/lon_vilshe_dev_01
>>
>> 1 active, 32766 maximum
>>
>> NOTE: The values in the "size" and "free" columns for DBspace
>> chunks are
>>
>> displayed in terms of "pgsize" of the DBspace to which they belong.
>>
>> Expanded chunk capacity mode: always
>>
>> I have redone this series of tasks several times now and I am
>> VERY annoyed with what is happening (losing all my dbspaces
>> everytime).
>>
>> Has anyone come across this kind of problem and/or would
>> anyone be aware of any reason why IDS would be trashing my
>> dbspaces in this manner?
>>
>> Please note that no error message is logged in the error
>> message file (MSGPATH).
>>
>> Hope someone can help me get rid of this annoying situation.
>>
>> Best regards,
>>
>> Daniel Dansereau
>>
>> Systèmes LogikInfo Inc.
>>
>>
>> daniel.dansereau@logikinfo.com
>>
>> Cell: (514) 262-3166
>>
>> Tel: (514) 426-4886
>>
>> Fax: (514) 426-0499
>>
>>
>> **************************************************************
>> *****************
>> Forum Note: Use "Reply" to post a response in the
>> discussion forum.
>>
>
>
>
don't use -i option on oninit command, it will delete all your
dbspaces/chunk
u can use oninit -y to online your ids
--
www.wahyunet.com
oninit -i initializes all disk structures. It is ONLY Used to initialize a newinstance. Once the instance is setup you just have to run 'oninit' or 'oninit
-v' (for verbose output during startup). The -i is wiping out what you setup
after the initial startup. You can either do it all again or use the ontape
archive to restore the instance.
Art S. Kagel
----- Original Message -----
From: Daniel Dansereau <ids@iiug.org>
At: 11/05 18:25:39
Good day all,
My problem has to do with the IDS 10 server I am currently running on an IBM
pServer p505 and AIX 5.3.
My true setup is IDS 10.00.UC4 on AIX 5.3 rel 5:
# dbaccess -V --> DB-Access Version 10.00.UC4
# oslevel -r --> 5300-05
My problem occurs in the following manner:
1. I setup my dbspaces as needed; following are the onspaces commands
that I run:
* onspaces -c -d regular_dbs1 -p /dev/lon_vilshe_dev_02 -o 0 -s
1048576
* onspaces -c -d hi_use_dbs1 -p /dev/lon_vilshe_dev_03 -o 0 -s 1048576
* onspaces -c -d data_whse1 -p /dev/lon_vilshe_dev_04 -o 0 -s 2097152
* onspaces -c -d tmp_dbs1 -p /dev/lon_vilshe_dev_t01 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs2 -p /dev/lon_vilshe_dev_t02 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs3 -p /dev/lon_vilshe_dev_t03 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs4 -p /dev/lon_vilshe_dev_t04 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs5 -p /dev/lon_vilshe_dev_t05 -o 0 -s 102400 -t
* onspaces -c -d tmp_dbs6 -p /dev/lon_vilshe_dev_t06 -o 0 -s 102400 -t
2. Running the onstat -d command at this point shows that the newly
created dbspaces/chunks are all present and created as required.
# onstat -d
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 01:20:33
-- 72368 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner
name
4012a7e8 1 0x60001 1 1 4096 N B informix
rootdbs
5032b1d0 2 0x60001 2 1 4096 N B informix
regular_dbs1
5032b8a0 3 0x60001 3 1 4096 N B informix
hi_use_dbs1
50332018 4 0x60001 4 1 4096 N B informix
data_whse1
50332678 5 0x42001 5 1 4096 N TB informix
tmp_dbs1
50332de0 6 0x42001 6 1 4096 N TB informix
tmp_dbs2
50333578 7 0x42001 7 1 4096 N TB informix
tmp_dbs3
50333d10 8 0x42001 8 1 4096 N TB informix
tmp_dbs4
503344a8 9 0x42001 9 1 4096 N TB informix
tmp_dbs5
50334c40 10 0x42001 10 1 4096 N TB informix
tmp_dbs6
10 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags
pathname
4012a948 1 1 0 20480 10340 PO-B
/dev/lon_vilshe_dev_01
5032b330 2 2 0 262144 262091 PO-B
/dev/lon_vilshe_dev_02
5032ba00 3 3 0 262144 262091 PO-B
/dev/lon_vilshe_dev_03
50332178 4 4 0 524288 524235 PO-B
/dev/lon_vilshe_dev_04
503327d8 5 5 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t01
50332f40 6 6 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t02
503336d8 7 7 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t03
50333e70 8 8 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t04
50334608 9 9 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t05
50334da0 10 10 0 25600 25547 PO-B
/dev/lon_vilshe_dev_t06
10 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always
3. I run ontape -s -L 0 (to get a level 0 backup)
# ontape -s -L 0
Archive to tape device '/dev/null' is complete.
Program over.
4. I shutdown the server using the onmode -ky command.
5. I restart the server with the oninit -iy command
# oninit -iy
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
with this Server instance, please make sure that your SHMBASE value
specifies in onconfig is 0x40000000L or above. Otherwise you will have
problems while attaching or dynamically adding virtual shared memory
segments. Please refer to Server machine notes for more information.
6. Running the onstat -d command at this point shows that the newly
created dbspaces/chunks have all disappeared.
# onstat -d
IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line -- Up 00:00:11
-- 72368 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner
name
4012a7e8 1 0x41001 1 1 4096 N B informix
rootdbs
1 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags
pathname
4012a948 1 1 0 20480 11384 PO-B
/dev/lon_vilshe_dev_01
1 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always
I have redone this series of tasks several times now and I am VERY annoyed
with what is happening (losing all my dbspaces everytime).
Has anyone come across this kind of problem and/or would anyone be aware of
any reason why IDS would be trashing my dbspaces in this manner?
Please note that no error message is logged in the error message file
(MSGPATH).
Hope someone can help me get rid of this annoying situation.
Best regards,
Daniel Dansereau
Syst
mes LogikInfo Inc.
<mailto:daniel.dansereau@logikinfo.com> daniel.dansereau@logikinfo.com
Cell: (514) 262-3166
Tel: (514) 426-4886
Fax: (514) 426-0499
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
just for remember
"to restart your instance, you put the server down (onmode -ky) and put your
server up (oninit -v)"
You´ll have no problem after that
André
>From: "Sonia Guerra" <isc92@yahoo.com>
>Reply-To: ids@iiug.org
>To: ids@iiug.org
>Subject: RE: Losing dbspaces/chunks after server shutdown [7727]
>Date: Sun, 5 Nov 2006 18:55:13 -0500 (EST)
>
>oninit -iy restart your Informix instance, you will have to create dbspaces>again and recover DB information from your last backup or dbexport.
>
>-i means initialize
>-y yes to all questions
>
>Paul Watson <paul@oninit.com> wrote:
>
>Its the the iy that is doing it, check the manual
>
>Paul Watson
>Tel: +44 1414161772
>Mob: +44 7818003457
>Web: www.oninit.com
>
>GO FURTHER with DB2
>GET THERE FASTER with Informix.
>Attend IDUG 2007 San Jose, North America
>May 6-10, 2006
>Visit http://www.iiug.org/conf for more information.
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> > Behalf Of Daniel Dansereau
> > Sent: 05 November 2006 17:17
> > To: ids@iiug.org
> > Subject: Losing dbspaces/chunks after server shutdown [7725]
> >
> >
> > Good day all,
> >
> > My problem has to do with the IDS 10 server I am currently
> > running on an IBM pServer p505 and AIX 5.3.
> >
> > My true setup is IDS 10.00.UC4 on AIX 5.3 rel 5:
> >
> > # dbaccess V --> DB-Access Version 10.00.UC4> >
> > # oslevel -r --> 5300-05
> >
> > My problem occurs in the following manner:
> >
> > 1. I setup my dbspaces as needed; following are the onspaces
> > commands that I run:
> >
> > * onspaces -c -d regular_dbs1 -p /dev/lon_vilshe_dev_02 -o 0 -s
> > 1048576
> > * onspaces -c -d hi_use_dbs1 -p /dev/lon_vilshe_dev_03 -o 0 -s 1048576
> > * onspaces -c -d data_whse1 -p /dev/lon_vilshe_dev_04 -o 0 -s 2097152
> > * onspaces -c -d tmp_dbs1 -p /dev/lon_vilshe_dev_t01 -o 0 -s 102400 -t
> > * onspaces -c -d tmp_dbs2 -p /dev/lon_vilshe_dev_t02 -o 0 -s 102400 -t
> > * onspaces -c -d tmp_dbs3 -p /dev/lon_vilshe_dev_t03 -o 0 -s 102400 -t
> > * onspaces -c -d tmp_dbs4 -p /dev/lon_vilshe_dev_t04 -o 0 -s 102400 -t
> > * onspaces -c -d tmp_dbs5 -p /dev/lon_vilshe_dev_t05 -o 0 -s 102400 -t
> > * onspaces -c -d tmp_dbs6 -p /dev/lon_vilshe_dev_t06 -o 0 -s
> > 102400 t
> >
> > 2. Running the onstat d command at this point shows that the
> > newly created dbspaces/chunks are all present and created as
> > required.
> >
> > # onstat -d> >
> > IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
> > Up 01:20:33
> > -- 72368 Kbytes> >
> > Dbspaces
> >
> > address number flags fchunk nchunks pgsize flags owner name
> >
> > 4012a7e8 1 0x60001 1 1 4096 N B informix rootdbs
> >
> > 5032b1d0 2 0x60001 2 1 4096 N B informix
> > regular_dbs1
> >
> > 5032b8a0 3 0x60001 3 1 4096 N B informix
> > hi_use_dbs1
> >
> > 50332018 4 0x60001 4 1 4096 N B informix
> > data_whse1
> >
> > 50332678 5 0x42001 5 1 4096 N TB informix
> > tmp_dbs1
> >
> > 50332de0 6 0x42001 6 1 4096 N TB informix
> > tmp_dbs2
> >
> > 50333578 7 0x42001 7 1 4096 N TB informix
> > tmp_dbs3
> >
> > 50333d10 8 0x42001 8 1 4096 N TB informix
> > tmp_dbs4
> >
> > 503344a8 9 0x42001 9 1 4096 N TB informix
> > tmp_dbs5
> >
> > 50334c40 10 0x42001 10 1 4096 N TB informix
> > tmp_dbs6
> >
> > 10 active, 2047 maximum
> >
> > Chunks
> >
> > address chunk/dbs offset size free bpages flags pathname
> >
> > 4012a948 1 1 0 20480 10340 PO-B
> > /dev/lon_vilshe_dev_01
> >
> > 5032b330 2 2 0 262144 262091 PO-B
> > /dev/lon_vilshe_dev_02
> >
> > 5032ba00 3 3 0 262144 262091 PO-B
> > /dev/lon_vilshe_dev_03
> >
> > 50332178 4 4 0 524288 524235 PO-B
> > /dev/lon_vilshe_dev_04
> >
> > 503327d8 5 5 0 25600 25547 PO-B
> > /dev/lon_vilshe_dev_t01
> >
> > 50332f40 6 6 0 25600 25547 PO-B
> > /dev/lon_vilshe_dev_t02
> >
> > 503336d8 7 7 0 25600 25547 PO-B
> > /dev/lon_vilshe_dev_t03
> >
> > 50333e70 8 8 0 25600 25547 PO-B
> > /dev/lon_vilshe_dev_t04
> >
> > 50334608 9 9 0 25600 25547 PO-B
> > /dev/lon_vilshe_dev_t05
> >
> > 50334da0 10 10 0 25600 25547 PO-B
> > /dev/lon_vilshe_dev_t06
> >
> > 10 active, 32766 maximum
> >
> > NOTE: The values in the "size" and "free" columns for DBspace
> > chunks are
> >
> > displayed in terms of "pgsize" of the DBspace to which they belong.
> >
> > Expanded chunk capacity mode: always
> >
> > 3. I run ontape s L 0 (to get a level 0 backup)
> >
> > # ontape -s -L 0> >
> > Archive to tape device '/dev/null' is complete.
> >
> > Program over.
> >
> > 4. I shutdown the server using the onmode ky command.
> >
> > 5. I restart the server with the oninit iy command
> >
> > # oninit -iy> >
> > WARNING : If you intend to use J/Foundation or GLS for
> > Unicode feature(GLU) with this Server instance, please make
> > sure that your SHMBASE value specifies in onconfig is
> > 0x40000000L or above. Otherwise you will have problems while
> > attaching or dynamically adding virtual shared memory
> > segments. Please refer to Server machine notes for more information.
> >
> > 6. Running the onstat d command at this point shows that the
> > newly created dbspaces/chunks have all disappeared.
> >
> > # onstat -d> >
> > IBM Informix Dynamic Server Version 10.00.UC4 -- On-Line --
> > Up 00:00:11
> > -- 72368 Kbytes> >
> > Dbspaces
> >
> > address number flags fchunk nchunks pgsize flags owner name
> >
> > 4012a7e8 1 0x41001 1 1 4096 N B informix rootdbs
> >
> > 1 active, 2047 maximum
> >
> > Chunks
> >
> > address chunk/dbs offset size free bpages flags pathname
> >
> > 4012a948 1 1 0 20480 11384 PO-B
> > /dev/lon_vilshe_dev_01
> >
> > 1 active, 32766 maximum
> >
> > NOTE: The values in the "size" and "free" columns for DBspace
> > chunks are
> >
> > displayed in terms of "pgsize" of the DBspace to which they belong.
> >
> > Expanded chunk capacity mode: always
> >
> > I have redone this series of tasks several times now and I am
> > VERY annoyed with what is happening (losing all my dbspaces
> > everytime).
> >
> > Has anyone come across this kind of problem and/or would
> > anyone be aware of any reason why IDS would be trashing my
> > dbspaces in this manner?
> >
> > Please note that no error message is logged in the error
> > message file (MSGPATH).
> >
> > Hope someone can help me get rid of this annoying situation.
> >
> > Best regards,
> >
> > Daniel Dansereau
> >
> > Systèmes LogikInfo Inc.
> >
> >
> > daniel.dansereau@logikinfo.com
> >
> > Cell: (514) 262-3166
> >
> > Tel: (514) 426-4886
> >
> > Fax: (514) 426-0499
> >
> >
> > **************************************************************
> > *****************
> > Forum Note: Use "Reply" to post a r
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape