IDS Forum

RE: Losing dbspaces/chunks after server shutdown

Posted By: Sonia Guerra
Date: Sunday, 5 November 2006, at 6:55 p.m.

In Response To: RE: Losing dbspaces/chunks after server shutdown (Paul Watson)

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:

It’s 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.

Messages In This Thread

• Losing dbspaces/chunks after server shutdown
  Daniel Dansereau -- Sunday, 5 November 2006, at 6:17 p.m.
  • RE: Losing dbspaces/chunks after server shutdown
    Paul Watson -- Sunday, 5 November 2006, at 6:30 p.m.
    • RE: Losing dbspaces/chunks after server shutdown
      Sonia Guerra -- Sunday, 5 November 2006, at 6:55 p.m.
      • Re: Losing dbspaces/chunks after server shutdown
        Wahyu Cahyadi -- Monday, 6 November 2006, at 3:58 a.m.
      • RE: Losing dbspaces/chunks after server shutdown
        André Luiz Rufino -- Thursday, 9 November 2006, at 6:44 a.m.
  • Re: Losing dbspaces/chunks after server shutdown
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 6 November 2006, at 10:31 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.