IDS Forum

Losing dbspaces/chunks after server shutdown

Posted By: Daniel Dansereau
Date: Sunday, 5 November 2006, at 6:17 p.m.

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

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.