Informix doesn`t start
A Windows IDS 11.50 user tried to enlarge rootdbs with onspaces -a, but mistakenly gave the directory (C:\\IFMXDATA\\ol_ids_1150_1) instead of the chunk file as the -p path. The server then failed to start with I/O errors and 'Primary Chunk ... Offline' assertion failures. Advice was to check ROOTPATH in the ONCONFIG (which was correct). After another reboot the instance came up normally. Jack Parker and Art Kagel explained that the initial rootdbs chunk/ROOTSIZE can't be resized once initialized; you must add a new chunk pointing at a real file with a sensible offset (or mark a chunk extendable via Admin API/OAT). The poster's later add worked but left a gap of unused space; no further verification is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
I`v got hudge problem,
Hope fore someone of you it will be simple to find what happen.
So, I try to resize my rootdbs,
I wrote a few commands sth. like this:
C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50>onspaces -a rootdbs -p
C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 -o 0 -s 400000
C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>onspaces -a rootdbs
-p C:\\\\IFMXDATA\\\\ol_ids_1150_1 -o 402000 -s 5120
after this i rebote whole machine, and... my db doesn`t start.
Logs from db are below.
http://www.fileserve.com/file/yjSgCgF/dblog.zip
Hope, will give me advice howto add free space to my rootdbs chunk
Piotr.
Sorry, can't/won't get to your log file. Can you just paste the last 20 =
lines from your online.log? %INFORMIXDIR%\\\\%INFORMIXSERVER%.log or =
online.log
j.
On Dec 24, 2011, at 8:34 AM, NOS PIOTR wrote:
> Hi,=20
> I`v got hudge problem,=20
> Hope fore someone of you it will be simple to find what happen.=20
> So, I try to resize my rootdbs,=20
> I wrote a few commands sth. like this:=20
>=20
> C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50>onspaces -a =
rootdbs -p=20
> C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 -o 0 -s 400000=20
>=20
> C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>onspaces -a =
rootdbs=20
> -p C:\\\\IFMXDATA\\\\ol_ids_1150_1 -o 402000 -s 5120=20
>=20
> after this i rebote whole machine, and... my db doesn`t start.=20
> Logs from db are below.=20
>=20
> http://www.fileserve.com/file/yjSgCgF/dblog.zip=20
>=20
> Hope, will give me advice howto add free space to my rootdbs chunk=20
>=20
> Piotr.=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
Ok, Hope i wont put a lot of trash.
ol_ids.log
14:10:33 Action: Please notify IBM Informix Technical Support.
14:10:33 stack trace for pid 1312 written to
C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.404cf29
14:10:47 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.404cf29
14:10:49 Releasing server from system block
14:10:51 I/O read chunk 6, pagenum 3, pagecnt 1 --> errno = 9
14:10:51 I/O read chunk 6, pagenum 3, pagecnt 1 --> errno = 9
14:10:52 Logical Recovery has reached the transaction cleanup phase.
14:10:52 Kernel asynchronous I/O (KAIO) cannot be used for file
'**C:\\\\IFMXDATA\\\\ol_ids_1150_1'.
14:10:52 KAIO: error in kaio_WRITE, kaiocbp = 0xef3ef10, errno = 1
14:10:52 fildes = 1528 (gfd 7), buf = 0x0D203000, nbytes = 4096, offset =
309256192
14:10:52 Kernel asynchronous I/O (KAIO) cannot be used for file
'**C:\\\\IFMXDATA\\\\ol_ids_1150_1'.
14:10:52 KAIO: error in kaio_WRITE, kaiocbp = 0xef40f10, errno = 1
14:10:52 fildes = 1520 (gfd 8), buf = 0x0D207000, nbytes = 4096, offset =
411656192
14:10:52 Assert Warning: I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1'
-- Offline
14:10:52 IBM Informix Dynamic Server Version 11.50.TC9IE
14:10:52 Who: Thread(14, flush_sub(2), 0, 1)
File: rsbuff.c Line: 5885
14:10:53 Results: Chunk is now unusable
14:10:53 Action: Repair and restore from mirror or archive
14:10:53 stack trace for pid 1312 written to
C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f6cf5c
14:11:05 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f6cf5c
14:11:05 Assert Warning: I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1'
-- Offline
14:11:05 IBM Informix Dynamic Server Version 11.50.TC9IE
14:11:05 Who: Thread(13, flush_sub(1), 0, 1)
File: rsbuff.c Line: 5885
14:11:06 Results: Chunk is now unusable
14:11:06 Action: Repair and restore from mirror or archive
14:11:06 stack trace for pid 1312 written to
C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f5cf69
14:11:18 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f5cf69
14:11:19 Assert Warning: I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1'
-- Offline
14:11:19 IBM Informix Dynamic Server Version 11.50.TC9IE
14:11:19 Who: Thread(15, flush_sub(3), 0, 1)
File: rsbuff.c Line: 5885
14:11:19 Results: Chunk is now unusable
14:11:19 Action: Repair and restore from mirror or archive
14:11:19 stack trace for pid 1312 written to
C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f7cf6a
14:11:20 Releasing server from system block
14:11:31 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f7cf6a
14:11:31 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- Offline
14:11:31 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- Offline
14:11:31 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- Offline
14:11:32 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- Offline
14:11:33 Releasing server from system block
14:11:35 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- Offline
14:11:35 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- Offline
And af.3f7cf6a
===========------------- - - - - - -
C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\bin\\\\onmode -V:
IBM Informix Dynamic Server Version 11.50.TC9IE Software Serial Number
AAA#B000000
-------------------------------
End System Alarm Program Output
-------------------------------
14:11:35 C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50/etc/evidence.bat 1
C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp af.3f7cf6a 0 0x0 15 0xf1dd018 1025 0 0 0 0
14:11:35
------------------ End of assertion failure 0 -----------------
The engine is looking for the rootdbs at 'C:\\\\IFMXDATA\\\\ol_ids_1150_1 and =
having issues with it. =46rom your first email, that sounds like the =
directory where ROOTDBS should live, not the dbspace itself.
Check your %INFORMIXDIR%\\\\etc\\\\%ONCONFIG% file and ensure that the ROOTDBS =
is spelled out correctly and exists as a file. I'm here, for a bit, so =
let me know.
j.
On Dec 24, 2011, at 8:56 AM, NOS PIOTR wrote:
> Ok, Hope i wont put a lot of trash.=20
>=20
> ol_ids.log=20
>=20
> 14:10:33 Action: Please notify IBM Informix Technical Support.=20
> 14:10:33 stack trace for pid 1312 written to=20
> C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.404cf29=20
> 14:10:47 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.404cf29=20
> 14:10:49 Releasing server from system block=20
> 14:10:51 I/O read chunk 6, pagenum 3, pagecnt 1 --> errno =3D 9=20
> 14:10:51 I/O read chunk 6, pagenum 3, pagecnt 1 --> errno =3D 9=20
> 14:10:52 Logical Recovery has reached the transaction cleanup phase.=20=
> 14:10:52 Kernel asynchronous I/O (KAIO) cannot be used for file=20
> '**C:\\\\IFMXDATA\\\\ol_ids_1150_1'.=20
> 14:10:52 KAIO: error in kaio_WRITE, kaiocbp =3D 0xef3ef10, errno =3D 1=20=
> 14:10:52 fildes =3D 1528 (gfd 7), buf =3D 0x0D203000, nbytes =3D 4096, =
offset =3D=20
> 309256192=20
> 14:10:52 Kernel asynchronous I/O (KAIO) cannot be used for file=20
> '**C:\\\\IFMXDATA\\\\ol_ids_1150_1'.=20
> 14:10:52 KAIO: error in kaio_WRITE, kaiocbp =3D 0xef40f10, errno =3D 1=20=
> 14:10:52 fildes =3D 1520 (gfd 8), buf =3D 0x0D207000, nbytes =3D 4096, =
offset =3D=20
> 411656192=20
> 14:10:52 Assert Warning: I/O error, Primary Chunk =
'C:\\\\IFMXDATA\\\\ol_ids_1150_1'=20
> -- Offline=20
> 14:10:52 IBM Informix Dynamic Server Version 11.50.TC9IE=20
> 14:10:52 Who: Thread(14, flush_sub(2), 0, 1)=20
>=20
> File: rsbuff.c Line: 5885=20
> 14:10:53 Results: Chunk is now unusable=20
> 14:10:53 Action: Repair and restore from mirror or archive=20
> 14:10:53 stack trace for pid 1312 written to=20
> C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f6cf5c=20
> 14:11:05 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f6cf5c=20
> 14:11:05 Assert Warning: I/O error, Primary Chunk =
'C:\\\\IFMXDATA\\\\ol_ids_1150_1'=20
> -- Offline=20
> 14:11:05 IBM Informix Dynamic Server Version 11.50.TC9IE=20
> 14:11:05 Who: Thread(13, flush_sub(1), 0, 1)=20
>=20
> File: rsbuff.c Line: 5885=20
> 14:11:06 Results: Chunk is now unusable=20
> 14:11:06 Action: Repair and restore from mirror or archive=20
> 14:11:06 stack trace for pid 1312 written to=20
> C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f5cf69=20
> 14:11:18 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f5cf69=20
> 14:11:19 Assert Warning: I/O error, Primary Chunk =
'C:\\\\IFMXDATA\\\\ol_ids_1150_1'=20
> -- Offline=20
> 14:11:19 IBM Informix Dynamic Server Version 11.50.TC9IE=20
> 14:11:19 Who: Thread(15, flush_sub(3), 0, 1)=20
>=20
> File: rsbuff.c Line: 5885=20
> 14:11:19 Results: Chunk is now unusable=20
> 14:11:19 Action: Repair and restore from mirror or archive=20
> 14:11:19 stack trace for pid 1312 written to=20
> C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f7cf6a=20
> 14:11:20 Releasing server from system block=20
> 14:11:31 See Also: C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp\\\\af.3f7cf6a=20
> 14:11:31 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- =
Offline=20
> 14:11:31 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- =
Offline=20
> 14:11:31 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- =
Offline=20
> 14:11:32 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- =
Offline=20
> 14:11:33 Releasing server from system block=20
> 14:11:35 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- =
Offline=20
> 14:11:35 I/O error, Primary Chunk 'C:\\\\IFMXDATA\\\\ol_ids_1150_1' -- =
Offline=20
>=20
> And af.3f7cf6a=20
>=20
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D------------- - - - - - -=20
> C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\bin\\\\onmode -V:=20
> IBM Informix Dynamic Server Version 11.50.TC9IE Software Serial Number=20=
> AAA#B000000=20
>=20
> -------------------------------=20
> End System Alarm Program Output=20
> -------------------------------=20
>=20
> 14:11:35 C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50/etc/evidence.bat 1=20
> C:\\\\PROGRA~1\\\\IBM\\\\IBMINF~1\\\\11.50\\\\tmp af.3f7cf6a 0 0x0 15 0xf1dd018 1025 =
0 0 0 0=20
> 14:11:35=20
> ------------------ End of assertion failure 0 -----------------=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
Sorry, I can not post yesterday. The path where all file are is: C:\\\\IFMXDATA\\\\ol_ids_1150_1 File name is: rootdbs_dat.000 I do the copy of rootdbs_dat so i can experiment on "living body" Varible(informixdir) in setnet32 is: C:\\\\Program Files\\\\IBM\\\\Informix\\\\Client-SDK I think that isent a problem, becouse I dident change it yesterday and it work correctly. I services i can`t even start the Ids service. Thank you for your attention. Piotr
Check your %INFORMIXDIR%\\\\etc\\\\%ONCONFIG% file and ensure that the ROOTDBS=20= is spelled out correctly and exists as a file. =20 ROOTDBS should therefore be: > C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 Please check and see if it is. j. On Dec 25, 2011, at 1:06 AM, NOS PIOTR wrote: > Sorry, I can not post yesterday.=20 >=20 > The path where all file are is:=20 > C:\\\\IFMXDATA\\\\ol_ids_1150_1=20 >=20 > File name is:=20 > rootdbs_dat.000=20 >=20 > I do the copy of rootdbs_dat so i can experiment on "living body"=20 >=20 > Varible(informixdir) in setnet32 is:=20 > C:\\\\Program Files\\\\IBM\\\\Informix\\\\Client-SDK=20 >=20 > I think that isent a problem, becouse I dident change it yesterday and = it work=20 > correctly.=20 >=20 > I services i can`t even start the Ids service.=20 >=20 > Thank you for your attention.=20 >=20 > Piotr=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20
>ROOTDBS should therefore be: > C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 It is But the ROOTDBS=20= dosent even exist in ONCONFIG.ol_ids_1150_1 Should I past it? Im not sure we looking in good place, bocuse that base was a well prosper data base, and I just resize a rootdbs.
That parameter should be ROOTPATH. Art On Dec 25, 2011 10:03 AM, <> wrote: > >ROOTDBS should therefore be: > > C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 > > It is > > But the ROOTDBS=20= dosent even exist in ONCONFIG.ol_ids_1150_1 > > Should I past it? > > Im not sure we looking in good place, bocuse that base was a well prosper > data > base, and I just resize a rootdbs. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340f613f007504b4ebf977
Thanks Art. Piotr,=20 Your log indicates that the engine is trying to open your directory=20 as rootdbs instead of the actual file - so that means we should check that it is set properly in the onconfig file. Please ignore the "=3D" that my mailer inserts at the end of long lines. Merry christmas, I've got to take off for the day and do family stuff, I'll check back in tonight. j. On Dec 25, 2011, at 10:05 AM, Art Kagel wrote: > That parameter should be ROOTPATH.=20 >=20 > Art=20 > On Dec 25, 2011 10:03 AM, <> wrote:=20 >=20 >>> ROOTDBS should therefore be:=20 >>> C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000=20 >>=20 >> It is=20 >>=20 >> But the ROOTDBS=3D20=3D dosent even exist in ONCONFIG.ol_ids_1150_1=20= >>=20 >> Should I past it?=20 >>=20 >> Im not sure we looking in good place, bocuse that base was a well = prosper=20 >> data=20 >> base, and I just resize a rootdbs.=20 >>=20 >>=20 >>=20 >>=20 > = **************************************************************************= *****=20 >> Forum Note: Use "Reply" to post a response in the discussion forum.=20= >>=20 >>=20 >=20 > --14dae9340f613f007504b4ebf977=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20
Hi, maybe this will help,
Few varibles from ONCONFIG.ol_ids_1150_1
ROOTNAME rootdbs
ROOTPATH C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 # Path for devicecontaining root dbspace
ROOTOFFSET 0
ROOTSIZE 204800 # Size of root dbspace (Kbytes)
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0
The varibles looks good(imho), sorry i dident saw them before, i just paste
rootdbs to search engine and dident saw thouse varivles.
Im wonder, if i will change the value of rootsize to 404800, It will do the
trick?
Becouse i need to expend my rootdbs.
Art, Jack, I hope that You will seat when You will read this text. I just reboot whole machine and base started properly... I heavent done anything else. What can i say? This is just windows? Belowe are logs after reebot, there nothing "special" 09:05:00 IBM Informix Dynamic Server Started. 09:05:00 Warning: The IBM IDS Innovator-C Edition license restriction limits 09:05:00 the total shared memory size for this server to 2097152 KB. 09:05:00 The maximum allowable shared memory was reset to this size to start the database server. 09:05:00 Requested shared memory segment size rounded from 32656KB to 32704KB 09:05:00 Could not disable priority aging: errno = 0 Mon Dec 26 09:05:00 2011 09:05:00 Warning: PDQ functionality is not supported in IDS Innovator-C Edition. The value of MAX_PDQPRIORITY cannot be set to 100. It is reset to 0. 09:05:00 Booting Language <c> from module <> 09:05:01 Loading Module <CNULL> 09:05:01 Booting Language <builtin> from module <> 09:05:01 Loading Module <BUILTINNULL> 09:05:01 Could not disable priority aging: errno = 0 09:05:07 DR: DRAUTO is 0 (Off) 09:05:07 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 09:05:07 IBM Informix Dynamic Server Version 11.50.TC9IE Software Serial Number AAA#B000000 09:05:08 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 09:05:08 Started 1 B-tree scanners. 09:05:08 B-tree scanner threshold set at 5000. 09:05:08 B-tree scanner range scan size set to -1. 09:05:08 B-tree scanner ALICE mode set to 6. 09:05:08 B-tree scanner index compression level set to med. 09:05:08 Physical Recovery Started at Page (1:5839). 09:05:08 Listen thread init SUCCESS 09:05:08 Listen thread init SUCCESS 09:05:08 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 09:05:09 Logical Recovery Started. 09:05:09 10 recovery worker threads will be started. 09:05:10 Logical Recovery has reached the transaction cleanup phase. 09:05:10 Logical Recovery Complete. 4 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 09:05:11 Onconfig parameter STORAGE_FULL_ALARM modified from 0 to 3. 09:05:11 Dataskip is now OFF for all dbspaces 09:05:11 Init operation complete - Mode Online 09:05:12 Checkpoint Completed: duration was 1 seconds. 09:05:12 Mon Dec 26 - loguniq 229, logpos 0x495018, timestamp: 0x254e13e Interval: 17007 09:05:12 Maximum server connections 0 09:05:12 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 12, Llog used 1 09:05:12 On-Line Mode 09:05:14 SCHAPI: Started dbScheduler thread. 09:05:15 Booting Language <spl> from module <> 09:05:15 Loading Module <SPLNULL> 09:05:15 SCHAPI: Started 2 dbWorker threads. 09:05:23 Performance Advisory: Based on the current workload, the physical log might be too small to accommodate the time it takes to flush the buffer pool. 09:05:23 Results: The server might block transactions during checkpoints. 09:05:23 Action: If transactions are blocked during the checkpoint, increase the size of the physical log to at least 175560 KB. 09:05:23 Performance Advisory: The physical log is too small for automatic checkpoints. 09:05:23 Results: Automatic checkpoints are disabled. 09:05:23 Action: To enable automatic checkpoints, increase the physical log to at least 175560 KB. 09:06:46 Checkpoint Completed: duration was 4 seconds. 09:06:46 Mon Dec 26 - loguniq 229, logpos 0x576194, timestamp: 0x258b203 Interval: 17008 09:06:46 Maximum server connections 0 09:06:47 Checkpoint Statistics - Avg. Txn Block Time 0.004, # Txns blocked 2, Plog used 9376, Llog used 543 09:06:52 Logical Log 229 Complete, timestamp: 0x2590f7f. Thank you for your "good word". And maybe You will help me how to resize rootdbs space, in easy way?
Sorry for third "post after post"
I do the
C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>onspaces -a
ol_ids_11
50_1 -p C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 -o 520000 -s 52000
Verifying physical disk space, please wait ...
Chunk successfully added.
I`m just wonder is this ok?
Is this will be the extension for my rootdbs?
Im not sure bocouse in OAT i see another chunk that calls ol_ids... physical
path is C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000.
No I see thee rootdbs size in OAT is 200mb and phisical file on drive is ~500mb
Just hope that knowladge will be helpful for someone..
That's good news. I've been on windows for a while,=20
and haven't seen this behaviour yet, but then I=20
skipped 11.5.
Once initialized, you can't change the size of the
initial chunk of rootdbs - this fellow:
ROOTSIZE 204800 # Size of root dbspace (Kbytes)=20So leave that entry alone in your %ONCONFIG%.
You can add a second chunk to it, which is what
it looks like you were doing in your first email.
Run an "onstat -d" and see if you now have two
chunks in the rootdbs dbspace.
It would look something like:
Top section:
Dbspaces
address number flags fchunk nchunks pgsize flags =
owner name
2058746a8 3 0x40001 1 2 4096 =
N BA informix rootdbs
Bottom Section:
Chunks
address chunk/dbs offset size free bpages =
flags pathname
2058741d0 1 1 0 50000 29173 =
PO-B-D C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000
205874ba0 2 1 0 100000 34947 =
PO-B-D C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.001
Your command was close the first time except:
onspaces -a rootdbs -p C:\\\\IFMXDATA\\\\ol_ids_1150_1 -o 402000 -s 5120
You needed to give it the name of a file, not a directory,
the -o 402000 is saying you want to offset by 402MB into the file
and the -s is the size you want to create it. 5MB isn't going to be =
worth the trouble.
You can actually use the same file that you used the first time =
(rootdbs_dat.000)=20
and offset it by 204800, - that way you don't have to create a second =
file, but it hides
what you have done from plain sight.
Something like this make more sense:
onspaces -a rootdbs -p C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.001 -o 0 -s =512000
First, that file rootdbs_dat.001 must exist. And easy way to create it =
is to:
copy con rootdbs_dat.001
[CTRL-Z]
So you are copying from the keyboard to the file
and the first thing you type is [CTRL-Z] - the end of file
marker in DOS. That while create an empty file.
Merry Xmas.
j.
On Dec 26, 2011, at 3:36 AM, NOS PIOTR wrote:
> Art, Jack,=20
> I hope that You will seat when You will read this text.=20
> I just reboot whole machine and base started properly...=20
> I heavent done anything else.=20
> What can i say?=20
> This is just windows?=20
>=20
> Belowe are logs after reebot, there nothing "special"=20
>=20
> 09:05:00 IBM Informix Dynamic Server Started.=20
> 09:05:00 Warning: The IBM IDS Innovator-C Edition license restriction =
limits=20
> 09:05:00 the total shared memory size for this server to 2097152 KB.=20=
> 09:05:00 The maximum allowable shared memory was reset to this size to =
start=20
> the database server.=20
> 09:05:00 Requested shared memory segment size rounded from 32656KB to =
32704KB=20
> 09:05:00 Could not disable priority aging: errno =3D 0=20
>=20
> Mon Dec 26 09:05:00 2011=20
>=20
> 09:05:00 Warning: PDQ functionality is not supported in IDS =
Innovator-C=20
> Edition.=20
>=20
> The value of MAX_PDQPRIORITY cannot be set to 100. It is reset to 0.=20=
> 09:05:00 Booting Language <c> from module <>=20
> 09:05:01 Loading Module <CNULL>=20
> 09:05:01 Booting Language <builtin> from module <>=20
> 09:05:01 Loading Module <BUILTINNULL>=20
> 09:05:01 Could not disable priority aging: errno =3D 0=20
> 09:05:07 DR: DRAUTO is 0 (Off)=20
> 09:05:07 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)=20
> 09:05:07 IBM Informix Dynamic Server Version 11.50.TC9IE Software =
Serial=20
> Number AAA#B000000=20
> 09:05:08 IBM Informix Dynamic Server Initialized -- Shared Memory =
Initialized.=20
>=20
> 09:05:08 Started 1 B-tree scanners.=20
> 09:05:08 B-tree scanner threshold set at 5000.=20
> 09:05:08 B-tree scanner range scan size set to -1.=20
> 09:05:08 B-tree scanner ALICE mode set to 6.=20
> 09:05:08 B-tree scanner index compression level set to med.=20
> 09:05:08 Physical Recovery Started at Page (1:5839).=20
> 09:05:08 Listen thread init SUCCESS=20
> 09:05:08 Listen thread init SUCCESS=20
> 09:05:08 Physical Recovery Complete: 0 Pages Examined, 0 Pages =
Restored.=20
> 09:05:09 Logical Recovery Started.=20
> 09:05:09 10 recovery worker threads will be started.=20
> 09:05:10 Logical Recovery has reached the transaction cleanup phase.=20=
> 09:05:10 Logical Recovery Complete.=20
>=20
> 4 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks=20
>=20
> 09:05:11 Onconfig parameter STORAGE_FULL_ALARM modified from 0 to 3.=20=
> 09:05:11 Dataskip is now OFF for all dbspaces=20
> 09:05:11 Init operation complete - Mode Online=20
> 09:05:12 Checkpoint Completed: duration was 1 seconds.=20
> 09:05:12 Mon Dec 26 - loguniq 229, logpos 0x495018, timestamp: =
0x254e13e=20
> Interval: 17007=20
>=20
> 09:05:12 Maximum server connections 0=20
> 09:05:12 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns =
blocked 0,=20
> Plog used 12, Llog used 1=20
>=20
> 09:05:12 On-Line Mode=20
> 09:05:14 SCHAPI: Started dbScheduler thread.=20
> 09:05:15 Booting Language <spl> from module <>=20
> 09:05:15 Loading Module <SPLNULL>=20
> 09:05:15 SCHAPI: Started 2 dbWorker threads.=20
> 09:05:23 Performance Advisory: Based on the current workload, the =
physical log=20
> might be too small to=20
> accommodate the time it takes to flush the buffer pool.=20
> 09:05:23 Results: The server might block transactions during =
checkpoints.=20
> 09:05:23 Action: If transactions are blocked during the checkpoint, =
increase=20
> the size of the=20
> physical log to at least 175560 KB.=20
> 09:05:23 Performance Advisory: The physical log is too small for =
automatic=20
> checkpoints.=20
> 09:05:23 Results: Automatic checkpoints are disabled.=20
> 09:05:23 Action: To enable automatic checkpoints, increase the =
physical log to=20
> at least 175560 KB.=20
> 09:06:46 Checkpoint Completed: duration was 4 seconds.=20
> 09:06:46 Mon Dec 26 - loguniq 229, logpos 0x576194, timestamp: =
0x258b203=20
> Interval: 17008=20
>=20
> 09:06:46 Maximum server connections 0=20
> 09:06:47 Checkpoint Statistics - Avg. Txn Block Time 0.004, # Txns =
blocked 2,=20
> Plog used 9376, Llog used 543=20
>=20
> 09:06:52 Logical Log 229 Complete, timestamp: 0x2590f7f.=20
>=20
> Thank you for your "good word".=20
> And maybe You will help me how to resize rootdbs space, in easy way?=20=
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
So what you just did was offset the new chunk by 500MB into the same =
file Since=20
that original chunk was 200MB, you may now have 300MB of dead space =
between the=20
end of your fist chunk and the start of the new one. =20
Take the output of "onstat -d" from the command line and send that =
along.
And don't worry about over-posting, it's better to talk it out than go =
off with only
half the idea.
j.
On Dec 26, 2011, at 8:44 AM, NOS PIOTR wrote:
> Sorry for third "post after post"=20
>=20
> I do the=20
> C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>onspaces -a=20=
> ol_ids_11=20
> 50_1 -p C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 -o 520000 -s 52000=20=
> Verifying physical disk space, please wait ...=20
> Chunk successfully added.=20
>=20
> I`m just wonder is this ok?=20
> Is this will be the extension for my rootdbs?=20
> Im not sure bocouse in OAT i see another chunk that calls ol_ids... =
physical=20
> path is C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000.=20
> No I see thee rootdbs size in OAT is 200mb and phisical file on drive =
is=20
> ~500mb=20
>=20
> Just hope that knowladge will be helpful for someone..=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
What you did added another chunk to the root dbspace rather than expanding
the existing chunk. YOu have to use the SQL Admin API functions or OAT to
mark a chunk as expandable. Once you've done that it will expand itself.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Mon, Dec 26, 2011 at 8:44 AM, <> wrote:
> Sorry for third "post after post"
>
> I do the
> C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>onspaces -a
> ol_ids_11
> 50_1 -p C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 -o 520000 -s 52000
> Verifying physical disk space, please wait ...
> Chunk successfully added.
>
> I`m just wonder is this ok?
> Is this will be the extension for my rootdbs?
> Im not sure bocouse in OAT i see another chunk that calls ol_ids...
> physical
> path is C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000.
> No I see thee rootdbs size in OAT is 200mb and phisical file on drive is
> ~500mb
>
> Just hope that knowladge will be helpful for someone..
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae93411ab07a94204b5034002
In 11.5? I thought that was new in 11.7.
j.
On Dec 26, 2011, at 1:51 PM, Art Kagel wrote:
> What you did added another chunk to the root dbspace rather than =
expanding=20
> the existing chunk. YOu have to use the SQL Admin API functions or OAT =
to=20
> mark a chunk as expandable. Once you've done that it will expand =
itself.=20
>=20
> Art=20
>=20
> Art S. Kagel=20
> Advanced DataTools (www.advancedatatools.com)=20
> Blog: http://informix-myview.blogspot.com/=20
>=20
> Disclaimer: Please keep in mind that my own opinions are my own =
opinions=20
> and do not reflect on my employer, Advanced DataTools, the IIUG, nor =
any=20
> other organization with which I am associated either explicitly,=20
> implicitly, or by inference. Neither do those opinions reflect those =
of=20
> other individuals affiliated with any entity with which I am =
affiliated nor=20
> those of the entities themselves.=20
>=20
> On Mon, Dec 26, 2011 at 8:44 AM, <> wrote:=20
>=20
>> Sorry for third "post after post"=20
>>=20
>> I do the=20
>> C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>onspaces =
-a=20
>> ol_ids_11=20
>> 50_1 -p C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 -o 520000 -s 52000=20=
>> Verifying physical disk space, please wait ...=20
>> Chunk successfully added.=20
>>=20
>> I`m just wonder is this ok?=20
>> Is this will be the extension for my rootdbs?=20
>> Im not sure bocouse in OAT i see another chunk that calls ol_ids...=20=
>> physical=20
>> path is C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000.=20
>> No I see thee rootdbs size in OAT is 200mb and phisical file on drive =
is=20
>> ~500mb=20
>>=20
>> Just hope that knowladge will be helpful for someone..=20
>>=20
>>=20
>>=20
>>=20
> =
**************************************************************************=
*****=20
>> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>>=20
>>=20
>=20
> --14dae93411ab07a94204b5034002=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>=20
True, expanding existing chunks is an 11.70 feature, so the OP could not do
that at all anyway. Good catch Jack.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Mon, Dec 26, 2011 at 3:05 PM, Jack Parker <jack.parker4@verizon.net>wrote:
> In 11.5? I thought that was new in 11.7.
>
> j.
>
> On Dec 26, 2011, at 1:51 PM, Art Kagel wrote:
>
> > What you did added another chunk to the root dbspace rather than =
> expanding=20
> > the existing chunk. YOu have to use the SQL Admin API functions or OAT =
> to=20
> > mark a chunk as expandable. Once you've done that it will expand =
> itself.=20
> >=20
> > Art=20
> >=20
> > Art S. Kagel=20
> > Advanced DataTools (www.advancedatatools.com)=20
> > Blog: http://informix-myview.blogspot.com/=20
> >=20
> > Disclaimer: Please keep in mind that my own opinions are my own =
> opinions=20
> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor =
> any=20
> > other organization with which I am associated either explicitly,=20
> > implicitly, or by inference. Neither do those opinions reflect those =
> of=20
> > other individuals affiliated with any entity with which I am =
> affiliated nor=20
> > those of the entities themselves.=20
> >=20
> > On Mon, Dec 26, 2011 at 8:44 AM, <> wrote:=20
> >=20
> >> Sorry for third "post after post"=20
> >>=20
> >> I do the=20
> >> C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin>onspaces =
> -a=20
> >> ol_ids_11=20
> >> 50_1 -p C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 -o 520000 -s 52000=20=
>
> >> Verifying physical disk space, please wait ...=20
> >> Chunk successfully added.=20
> >>=20
> >> I`m just wonder is this ok?=20
> >> Is this will be the extension for my rootdbs?=20
> >> Im not sure bocouse in OAT i see another chunk that calls ol_ids...=20=
>
> >> physical=20
> >> path is C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000.=20
> >> No I see thee rootdbs size in OAT is 200mb and phisical file on drive =
> is=20
> >> ~500mb=20
> >>=20
> >> Just hope that knowladge will be helpful for someone..=20
> >>=20
> >>=20
> >>=20
> >>=20
> > =
> **************************************************************************=
> *****=20
> >> Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>
> >>=20
> >>=20
> >=20
> > --14dae93411ab07a94204b5034002=20
> >=20
> >=20
> > =
> **************************************************************************=
> *****=20
> > Forum Note: Use "Reply" to post a response in the discussion forum.=20=
>
> >=20
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340b8142537f04b5049f88
Ok It work. Thank you for your advice, it was very helpful. Evrything seams ok so its end of topic. Thank Art and Jack, one more time!