Why cant I create a database in a dbspace ?

11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: Downloaded via IIUG link and installed it. I created a custom DSS instance named "server" with a 128GB dbspace named "datadbs". Install wizard created a Windows user "informix". I connected to instance "server", logging in as "informix". Executed an SQL script "CREATE DATABASE voters IN datadbs NLSCASE INSENSITIVE;" This failed, then tried creating the db via dbaccess menu. In dbaccess, dbspaces options did not show "datadbs", only root, phys, log & sbs dbs', but when I do a dir of the dbspaces it shows "datadbs" with 107GB. I set the following values in "onconfig.server", but still no dice! DBCREATE_PERMISSION informix DBCREATE_PERMISSION public #DB_LIBRARY_PATH IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION 0 UNSECURE_ONSTAT 0 ADMIN_USER_MODE_WITH_DBSA 1 ADMIN_MODE_USERS public SSL_KEYSTORE_LABEL

Don't know if this is the case here, Frank but looking at http://www.ibm.com/developerworks/data/library/techarticle/dm-0801doe/ it shows that developer edition only supports 8 Gig of storage. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK J. COMPUTER Sent: Monday, December 10, 2012 10:58 AM To: ids@iiug.org Subject: Why cant I create a database in a dbspace ? [29052] 11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: Downloaded via IIUG link and installed it. I created a custom DSS instance named "server" with a 128GB dbspace named "datadbs". Install wizard created a Windows user "informix". I connected to instance "server", logging in as "informix". Executed an SQL script "CREATE DATABASE voters IN datadbs NLSCASE INSENSITIVE;" This failed, then tried creating the db via dbaccess menu. In dbaccess, dbspaces options did not show "datadbs", only root, phys, log & sbs dbs', but when I do a dir of the dbspaces it shows "datadbs" with 107GB. I set the following values in "onconfig.server", but still no dice! DBCREATE_PERMISSION informix DBCREATE_PERMISSION public #DB_LIBRARY_PATH IFX_EXTEND_ROLE 1 SECURITY_LOCALCONNECTION 0 UNSECURE_ONSTAT 0 ADMIN_USER_MODE_WITH_DBSA 1 ADMIN_MODE_USERS public SSL_KEYSTORE_LABEL ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

David, I created another test dbspace of only 2GB and still cant access it from the instance. I even tried logging in as a non-admin user and same result. I can see both the 128 and 2GB spaces from win cmd prompt, checked their permissions and it all looks ok. If dev edition is "limited to 8GB", then why would it allow me to create a 128GB without complaining?

It was a thought. I knew the limit is there, just didn't know how it is enforced. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK J. COMPUTER Sent: Monday, December 10, 2012 12:52 PM To: ids@iiug.org Subject: Re: RE: Why cant I create a database in a dbsp.... [29055] David, I created another test dbspace of only 2GB and still cant access it from the instance. I even tried logging in as a non-admin user and same result. I can see both the 128 and 2GB spaces from win cmd prompt, checked their permissions and it all looks ok. If dev edition is "limited to 8GB", then why would it allow me to create a 128GB without complaining? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Do you see datadbs I the onstat -d report or in sysmaster:sysdbspaces? How did you add the datadbs dbspace? Art On Dec 10, 2012 10:58 AM, "FRANK J. COMPUTER" <frank_in_pr@hotmail.com> wrote: > 11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: > > Downloaded via IIUG link and installed it. > > I created a custom DSS instance named "server" with a 128GB dbspace named > "datadbs". > > Install wizard created a Windows user "informix". > > I connected to instance "server", logging in as "informix". > > Executed an SQL script "CREATE DATABASE voters IN datadbs NLSCASE > INSENSITIVE;" > > This failed, then tried creating the db via dbaccess menu. > > In dbaccess, dbspaces options did not show "datadbs", only root, phys, log > & > sbs dbs', but when I do a dir of the dbspaces it shows "datadbs" with > 107GB. > > I set the following values in "onconfig.server", but still no dice! > > DBCREATE_PERMISSION informix > DBCREATE_PERMISSION public > #DB_LIBRARY_PATH > IFX_EXTEND_ROLE 1 > SECURITY_LOCALCONNECTION 0 > UNSECURE_ONSTAT 0 > ADMIN_USER_MODE_WITH_DBSA 1 > ADMIN_MODE_USERS public > SSL_KEYSTORE_LABEL> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b2e136f7cb07104d085358b

On Mon, Dec 10, 2012 at 4:58 PM, FRANK J. COMPUTER <frank_in_pr@hotmail.com>wrote: > 11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: > > Downloaded via IIUG link and installed it. > > I created a custom DSS instance named "server" with a 128GB dbspace named > "datadbs". > > Install wizard created a Windows user "informix". > > I connected to instance "server", logging in as "informix". > > Executed an SQL script "CREATE DATABASE voters IN datadbs NLSCASE > INSENSITIVE;" > How, with what tool, and what was the error returned? > > This failed, then tried creating the db via dbaccess menu. > > In dbaccess, dbspaces options did not show "datadbs", only root, phys, log > & > sbs dbs', but when I do a dir of the dbspaces it shows "datadbs" with > 107GB. > A "dir"? What do you see with an onstat -d? > > I set the following values in "onconfig.server", but still no dice! > > DBCREATE_PERMISSION informix > DBCREATE_PERMISSION public > #DB_LIBRARY_PATH > IFX_EXTEND_ROLE 1 > SECURITY_LOCALCONNECTION 0 > UNSECURE_ONSTAT 0 > ADMIN_USER_MODE_WITH_DBSA 1 > ADMIN_MODE_USERS public > SSL_KEYSTORE_LABEL> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Regards, -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf303b41216d8abf04d0866bde