Skip to main content

developerworkslabel >  Information Management  >  forumlabel  >  IBM DB2 Express Forum  >  developerWorks

another SQL1092N error creating a database    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     
 
 
loginbox.header
 loginbox.welcomelabel loginbox.guestlabel
loginbox.signin
This question is answered.

Reply to this Thread Reply to this Thread Post New Thread Post New Thread useraction.watchpage useraction.watchpage useraction.settings useraction.settings help.pagetitle help.pagetitle
Permlink Replies: 8 - Pages: 1 - Last Post: Nov 12, 2009 4:42 PM Last Post By: greg.fenton
cscs010

Posts: 9
Registered: Oct 16, 2006 04:45:12 PM
another SQL1092N error creating a database
Posted: Nov 02, 2009 03:37:57 PM 		 
Click to report abuse...   Click to reply to this thread Reply
I am just trying to run some of the sample in the 'getting started with db2-express c' book and others I can find and sometimes they work and other times I get a SQL1092N abend on my id (running on Windows xp). Before I give up on this non-sensical product which was obviously written by some geeks trying to inflate their egos by incorporating idiotic security measures they do not seem to know anything about (like being able to distinguish the difference between domain ids and native windows ids), can someone tell me why this command worked:

db2 CREATE DATABASE PRODEXPR AUTOMATIC STORAGE YES ON 'C:\' DBPATH ON 'C:\' USING CODESET IBM-1252 TERRITORY US COLLATE USING SYSTEM PAGESIZE 4096

and this one gets a SQL1092N error (both commands were issued right after each other, with the same configuration options in effect):

db2 CREATE DATABASE PRODEXPR ON C:\ AUTOCONFIGURE USING
MEM_PERCENT 25 APPLY DB AND DBM
Valued Contributor Z-Company

Posts: 234
Registered: Dec 04, 2007 11:08:12 AM
Re: another SQL1092N error creating a database
Posted: Nov 02, 2009 07:51:42 PM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
In db2 9.7 both commands works. I am local admin, db2admns group member and db2 extended security was turned on. Windows XP Pro.
cscs010

Posts: 9
Registered: Oct 16, 2006 04:45:12 PM
Re: another SQL1092N error creating a database
Posted: Nov 04, 2009 01:27:22 PM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
I think that the autoconfigure is causing the problems.

since I am new to db2 and have not yet come across any of this in the getting started manual (if these subjects are even mentioned in there):

1. how do i update the db2admins group, or even find what is in there or find the group for that matter?

2. how do i tell if extended security is set on?
Valued Contributor Z-Company

Posts: 234
Registered: Dec 04, 2007 11:08:12 AM
Re: another SQL1092N error creating a database
Posted: Nov 08, 2009 08:59:46 AM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
how do i update the db2admins group, or even find what is in there or find the group for that matter?

default group name is DB2ADMNS (without I) unless you changed it to different name during db2 install.

How to manage groups? Use tool which comes with your operating system - for example on windows XP - http://www.mcmcse.com/microsoft/guides/manage_groups.shtml

How to know if extended security is on?
db2set -g will return

DB2_EXTSECURITY=YES

extended security feature (default on) is managed by db2exts.exe command, check online infocenter for more details how to turn it on or off. With extended security turned on, there are additional security restrictions in place (permissions on database and instance files).

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0011802.html
cscs010

Posts: 9
Registered: Oct 16, 2006 04:45:12 PM
Re: another SQL1092N error creating a database
Posted: Nov 12, 2009 11:21:09 AM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
I thought i had access to just about most of the functions i was trying to do until I decided to recreate the sample database which did not get properly created at installation.
i get an sql102n trying to create the tables,using: db2sampl -sql -xml -force command.

these settings, along with external security are in place and my id is a member of the ADMINISTRATORS group:

SYSADM group name (SYSADM_GROUP) = ADMINISTRATORS
SYSCTRL group name (SYSCTRL_GROUP) = ADMINISTRATORS
SYSMAINT group name (SYSMAINT_GROUP) = ADMINISTRATORS
SYSMON group name (SYSMON_GROUP) = ADMINISTRATORS
cscs010

Posts: 9
Registered: Oct 16, 2006 04:45:12 PM
Re: another SQL1092N error creating a database
Posted: Nov 12, 2009 12:59:44 PM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
i turned external security off and got the same error.

how can i see the sql commands that are being used by db2sampl so that i can run them myself?

C:\db2e\IBM\SQLLIB\BIN>db2sampl -sql -xml -force -verbose -name SAMPLE

Creating database "SAMPLE"...
Existing "SAMPLE" database found...
Dropping and recreating database "SAMPLE"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "EBARKOW"...

--ERROR------------------

SQLSTATE =
Native Error Code = -1092

IBMCLI DriverDB2/NT SQL1092N "EBARKOW" does not have the authority to per
form the requested command or operation.

Creating tables with XML columns and XML data in schema "EBARKOW"...

--ERROR------------------

SQLSTATE =
Native Error Code = -1092

IBMCLI DriverDB2/NT SQL1092N "EBARKOW" does not have the authority to per
form the requested command or operation.


'db2sampl' processing complete.
cscs010

Posts: 9
Registered: Oct 16, 2006 04:45:12 PM
Re: another SQL1092N error creating a database
Posted: Nov 12, 2009 01:13:47 PM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
i do not know what this db2sampl -v8 option really means (described as 'create sample database from db2 udb v8') but it did work. so at least i have a working SAMPLE database to get more SQL1092N errors on, along with the others.

Until next time, thanks for the responses.
cscs010

Posts: 9
Registered: Oct 16, 2006 04:45:12 PM
Re: another SQL1092N error creating a database
Posted: Nov 12, 2009 01:14:17 PM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
until the next sql1092n error.
greg.fenton

Posts: 4
Registered: Nov 12, 2009 03:10:33 PM
Re: another SQL1092N error creating a database
Posted: Nov 12, 2009 04:42:33 PM   in response to: cscs010 in response to: cscs010thread.responsepost 		 
Click to report abuse...   Click to reply to this thread Reply
I notice from the original post on this thread that your two CREATE DATABASE statements differ by not having the AUTOCONFIGURE clause.

I wonder if this is related to the error (possible bug?) that I posted about a few minutes ago:

http://www.ibm.com/developerworks/forums/thread.jspa?threadID=290479&tstart=0

greg.fenton
Pages: 1
Go Back Back to Thread List
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 
MoreLess 

Update your My developerWorks profile and start connecting with others.

Point your RSS reader here for a feed of the latest messages in all forums