Created test dbspace is not visible IDS 12.1
A user on IDS 12.10 (SUSE Linux) ran onspaces -c -d to create a dbspace; the command reported that the chunk file must have READ/WRITE permissions for owner and group (660), and the new dbspace/chunks never appeared in onstat -d. He had set the chunk file to looser permissions (777/774), assuming 660 was just a minimum, and also restarted the server and fiddled with oninit's ownership (which should be 6754 root:informix). Resolution: setting the chunk file to exactly 660, owned by informix:informix, made the creation work; no restart is needed to add dbspaces.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi experts,
IDS Ver: 12.1
OS: Linux SUSE 11.3
I have added a test db space using onspaces command. It didnt throw any error.
But I cant see the created dbspace.
informix@ids:/opt/ibm/informix/bin> onspaces -c -d testDB1 -p
/opt/ibm/informix/storage/spaces/testDB1 -o 200 -s 2093150
Your evaluation license will expire on 2015-06-21 00:00:00
Verifying physical disk space, please wait ...
The chunk '/opt/ibm/informix/storage/spaces/testDB1' must have READ/WRITE
permissions for owner and group (660).
-------------
RW permission is given the chunk file.
I have restarted database using onmode -ky and onmode -s; But still the DB is
not available.
How to solve this.
Re run the onspaces command, the first attempt failed because of permissions
error.
You don't need to restart instance when adding dbspaces or chunks.
Sent from my iPhone
> On 28 Mar 2015, at 5:29 pm, NIGIL N <nigil10@gmail.com> wrote:
>
> Hi experts,
> IDS Ver: 12.1
> OS: Linux SUSE 11.3
>
> I have added a test db space using onspaces command. It didnt throw any
error.
> But I cant see the created dbspace.
>
> informix@ids:/opt/ibm/informix/bin> onspaces -c -d testDB1 -p
> /opt/ibm/informix/storage/spaces/testDB1 -o 200 -s 2093150
> Your evaluation license will expire on 2015-06-21 00:00:00
> Verifying physical disk space, please wait ...
> The chunk '/opt/ibm/informix/storage/spaces/testDB1' must have READ/WRITE
> permissions for owner and group (660).
>
> -------------
> RW permission is given the chunk file.
> I have restarted database using onmode -ky and onmode -s; But still the DB is
> not available.
> How to solve this.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
I have tried/rerun the onspaces command multiple times. Output is same and no
error messages. I am seeing the same behavior for adding chunks also. The
added chunks not visible when I give onstat -d or onstat.
This was the same command I was using in 11.7. So for 12.1 also I have set all
config parameters same as 11.7.
Here is the output of onstat. I have noticed that plog and llog space is less
or pages are not free. Will this cause problem? If yes, how to increase them.
Adding chunks to plogs failed.
onstat -dYour evaluation license will expire on 2015-06-21 00:00:00
IBM Informix Dynamic Server Version 12.10.FC4TL -- On-Line -- Up 01:53:12 --241284 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
44fb5028 1 0x40001 1 1 2048 N BA informix rootdbs
450d7050 2 0x1040001 2 1 2048 N PBA informix plog
450d7280 3 0x40001 3 1 2048 N BA informix llog
450d74b0 4 0x40001 4 1 2048 N BA informix datadbs1
450d76e0 5 0x40001 5 1 2048 N BA informix datadbs2
450d7910 6 0x40001 6 1 2048 N BA informix datadbs3
450d7b40 7 0x40001 7 1 8192 N BA informix data8dbs1
450d7d70 8 0x40001 8 1 8192 N BA informix data8dbs2
45fe4028 9 0x40001 9 1 8192 N BA informix data8dbs3
45fe4258 10 0x42001 10 1 8192 N TBA informix tmpdbspace
45fe4488 11 0x48001 11 1 2048 N SBA informix sbspace1
45fe46b8 12 0x4a001 12 1 2048 N UBA informix tmpsbspace
12 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
44fb5258 1 1 0 788480 762364 PO-B-D /opt/ibm/informix/storage/rootdbs
45fe5028 2 2 0 32768 0 PO-BED
/opt/ibm/informix/storage/ol_informix1210_plog_p_1
45fe6028 3 3 0 32768 15 PO-BED
/opt/ibm/informix/storage/ol_informix1210_llog_p_1
45fe7028 4 4 0 32768 32715 PO-BED
/opt/ibm/informix/storage/ol_informix1210_datadbs1_p_1
45fe8028 5 5 0 32768 32715 PO-BED
/opt/ibm/informix/storage/ol_informix1210_datadbs2_p_1
45fe9028 6 6 0 32768 32715 PO-BED
/opt/ibm/informix/storage/ol_informix1210_datadbs3_p_1
45fea028 7 7 0 8192 8139 PO-BED
/opt/ibm/informix/storage/ol_informix1210_data8dbs1_p_1
45feb028 8 8 0 8192 8139 PO-BED
/opt/ibm/informix/storage/ol_informix1210_data8dbs2_p_1
45fec028 9 9 0 8192 8139 PO-BED
/opt/ibm/informix/storage/ol_informix1210_data8dbs3_p_1
45fed028 10 10 0 8192 8139 PO-BE-
/opt/ibm/informix/storage/ol_informix1210_tmpdbspace_p_1
45fee028 11 11 0 32768 23802 23802 POSB-D
/opt/ibm/informix/storage/ol_informix1210_sbspace1_p_1
Metadata 1745 8466 1745
45fef028 12 12 0 32768 23802 23802 POSB--
/opt/ibm/informix/storage/ol_informix1210_tmpsbspace_p_1
Metadata 1745 8466 1745
12 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
What are the permissions of the oninit binary?
-------- Original message --------
From: NIGIL N <nigil10@gmail.com>
Date: 28/03/2015 07:32 (GMT+00:00)
To: ids@iiug.org
Subject: Re: Created test dbspace is not visible IDS 12.1 [34886]
I have tried/rerun the onspaces command multiple times. Output is same and no
error messages. I am seeing the same behavior for adding chunks also. The
added chunks not visible when I give onstat -d or onstat.
This was the same command I was using in 11.7. So for 12.1 also I have set all
config parameters same as 11.7.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
oninit binary had the permissions 774 with user as root and group as informix.
Then I have changed user to informix making it informix:informix. No success.
Now after these experiments, my server initialization(reset)
fails.(DISK_INIT=1; oninit -ivy). Need to checK why.
That's your problem: oninit should be 6754 root:informix, however I'd warn you
against changing it by hand, because judging by your original permissions,
it's likely that the ownership of all other knformix binaries are wrong.
Installing in a fresh directory might be your best option.
-------- Original message --------
From: NIGIL N <nigil10@gmail.com>
Date: 28/03/2015 15:53 (GMT+00:00)
To: ids@iiug.org
Subject: Re: Created test dbspace is not visible IDS 12.1 [34889]
oninit binary had the permissions 774 with user as root and group as informix.
Then I have changed user to informix making it informix:informix. No success.
Now after these experiments, my server initialization(reset)
fails.(DISK_INIT=1; oninit -ivy). Need to checK why.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
This file: /opt/ibm/informix/storage/spaces/testDB1 has to be owned by user
informix, group informix with permissions 660. The dbspace was not created
because these permissions were not correct.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.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 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 Sat, Mar 28, 2015 at 2:29 AM, NIGIL N <nigil10@gmail.com> wrote:
> Hi experts,
> IDS Ver: 12.1
> OS: Linux SUSE 11.3
>
> I have added a test db space using onspaces command. It didnt throw any
> error.
> But I cant see the created dbspace.
>
> informix@ids:/opt/ibm/informix/bin> onspaces -c -d testDB1 -p
> /opt/ibm/informix/storage/spaces/testDB1 -o 200 -s 2093150
> Your evaluation license will expire on 2015-06-21 00:00:00
> Verifying physical disk space, please wait ...
> The chunk '/opt/ibm/informix/storage/spaces/testDB1' must have READ/WRITE
> permissions for owner and group (660).
>
> -------------
> RW permission is given the chunk file.
> I have restarted database using onmode -ky and onmode -s; But still the DB
> is
> not available.
> How to solve this.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113ff0c29dfffd051262a018
Yes Art/Marco.. Issue resolved. The problem was permission. I thought minimum requirement is 660. Hence give given higher permissions like 777 and 774. Now I have reverted to 660 and it worked. I am surprised by this behavior. Must be for Security but I feel an appropriate error message should be thrown.
Honestly Nigil, the error message was pretty explicit. It said, basically,
that onspaces couldn't create the dbspace because the chunk did not have
660 permissions. Kind of nails the problem in my mind.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.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 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 Sun, Mar 29, 2015 at 3:52 AM, NIGIL N <nigil10@gmail.com> wrote:
> Yes Art/Marco.. Issue resolved. The problem was permission.
> I thought minimum requirement is 660. Hence give given higher permissions
> like
> 777 and 774. Now I have reverted to 660 and it worked.
> I am surprised by this behavior. Must be for Security but I feel an
> appropriate error message should be thrown.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1140f79473432605126bb096
I would think this should be expected behavior from any = =0D enterprise class database server. If you left these files=0D 777 then anyone on your computer could remove these =0D = files and all your data would be gone. =0D =0D Whi= le it is true in the monetary system that if I ask for $3.00 and =0Dyou give me a $5.00 that would cover the bill, but this same logic = =0D does not work in the mechanical world. If I ask for a 1/2 inc= h nut =0D a 3/4 inch nut will not work. I need what I a= sked for and more =0D is not always better. =0D =0D =0D =0D =0D =0D= John F. Miller III =0D STSM, Lead Architect = =0D [1]miller3@us.ibm.com = =0D 503-747-1366 =0D IBM Informix Dynamic Server (IDS) =0D -----ids-bounces@iiug.org wrote:= ----- >To: ids@iiug.org >From: "NIGIL N" >Se= nt by: ids-bounces@iiug.org >Date: 03/29/2015 12:53AM >Subject:= Re: Created test dbspace is not visible IDS 12.1 [34893] > >>Yes Art/Marco.. Issue resolved. The problem was permission. >I= thought minimum requirement is 660. Hence give given higher >permiss= ions like >777 and 774. Now I have reverted to 660 and it worked. >I am surprised by this behavior. Must be for Security but I feel an <= BR>>appropriate error message should be thrown. > > >= ********************************************************************* &g= t;********** > Forum Note: Use "Reply" to post a response in t= he discussion forum. > References 1. 3D"mailto:miller3@us.ibm.com"
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