Topic
  • 1 reply
  • Latest Post - ‏2013-07-24T13:23:46Z by Sreeharsha_Naik
QE1B_John_Muir
QE1B_John_Muir
1 Post

Pinned topic Cannot create sample database

‏2013-07-19T19:17:55Z |

I installed db2 express-c onto my PC - Windows 7 Enterprise 32-bit.  When "DB2 First Steps" window opens, I click "Create sample database" and get

Creating database "SAMPLE" on path "C:"...

  Attempt to create the database "SAMPLE" failed.

  SQL1092N  The requested command or operation failed because the user ID does

not have the authority to perform the requested command or operation.  User ID:

"ID3457

  'db2sampl' processing complete.

Then I tried Start > All Programs > IBM DB2 DB2COPY3 > DB2 Command Window - Administrator

and typed "db2sampl" and got:

C:\Program Files\IBM\SQLLIB\BIN>db2sampl

 

  Creating database "SAMPLE"...

  Attempt to create the database "SAMPLE" failed.

  SQL1092N  The requested command or operation failed because the user ID does

not have the authority to perform the requested command or operation.  User ID:

 

"ID34571".

My install response file contains:

PROD=EXPRESS_C

LIC_AGREEMENT=ACCEPT

FILE=C:\Program Files\IBM\SQLLIB\

INSTALL_TYPE=CUSTOM

COMP=APPLICATION_DEVELOPMENT_TOOLS

COMP=BASE_CLIENT

COMP=DOTNET_DATA_PROVIDER

COMP=FIRST_STEPS

COMP=SPATIAL_EXTENDER_CLIENT_SUPPORT

COMP=DB2_UPDATE_SERVICE

COMP=JAVA_RUNTIME_SUPPORT

COMP=JDBC_SUPPORT

COMP=LDAP_EXPLOITATION

COMP=ODBC_SUPPORT

COMP=OLE_DB_SUPPORT

COMP=DB2_SAMPLE_DATABASE

COMP=SQLJ_SUPPORT

COMP=SSH_SERVER

COMP=WMI_PROVIDER

 

LANG=EN

DAS_CONTACT_LIST=LOCAL

INSTANCE=DB2

DB2.NAME=DB2_02

DEFAULT_INSTANCE=DB2

DB2.SVCENAME=db2c_DB2_02

DB2.SYSADM_GROUP=POL_StandardAccess

DB2.SYSCTRL_GROUP=POL_StandardAccess

DB2.DB2COMM=TCPIP

DB2_OLEDB_GUID={382D8A0D-D5BC-4C90-8C1D-D24990860ED5}

DB2_OLEDB_ADVANCED_PAGE_GUID={53EF545F-9A1A-452F-866F-5B0422387341}

DB2_OLEDB_CONNECTION_PAGE_GUID={691E932C-E58B-44B9-AA31-04A83A7FE402}

DB2_OLEDB_ENUMERATOR_GUID={950019DD-0E61-497A-9C67-D339650117CE}

DB2_OLEDB_ERROR_LOOKUP_GUID={EF79EAD3-FEA6-44C7-878D-98B989B82FFC}

DB2.PORT_NUMBER=50001

SSH_SERVER_INSTALL_DIR=D:\Program Files\IBM\IBM SSH Server\

DB2.AUTOSTART=YES

DB2.USERNAME=LocalSystem

DB2.PASSWORD=103816324722463345522766387396170449024267476644320954561422772349797212603760874039944449073141689045344642829298535774471252644628383535440903228167595451130556031425954326405272536515730054435638912466635438659527322548336559874457052148854987444175542427574944931317686754834488607725585620341316044536458364685771480763184244442296443674543706327983656364361534435655070284025335950457543043190633559643783463715811355044486545992273286965563514094505925493883664293496901050042655324304265606646673995743173748934732893261027129602724637695472493881184026767203248766314123678801503920316244353783333665347769516477107229251651195746335814442696773635620056263244471280707050007876727432580226855205673732229535694248707915426570566295065920248434974693497943964

ENCRYPTED=DB2.PASSWORD

DB2_EXTSECURITY=NO

DB2_USERSGROUP_NAME=DB2USERS

DB2_ADMINGROUP_NAME=DB2ADMNS

DB2_COMMON_APP_DATA_TOP_PATH=C:\ProgramData

RSP_FILE_NAME=C:\Users\ID34571\Documents\PROD_EXPC.rsp

DB2_COPY_NAME=DB2COPY3

DEFAULT_COPY=YES

DEFAULT_CLIENT_INTERFACE_COPY=YES

 

HELP! please.

Updated on 2013-07-19T19:26:22Z at 2013-07-19T19:26:22Z by QE1B_John_Muir
  • Sreeharsha_Naik
    Sreeharsha_Naik
    34 Posts

    Re: Cannot create sample database

    ‏2013-07-24T13:23:46Z  

    John,

    If you are on windows 7 - Go to Computer Management by right clicking " My computer " Icon and look for Local Users and groups, You will find DB2ADMN and DB2USERS group created, check whether your user Id is a part of these two groups, if not add them and then try to create the database.

    If it does not work, try to attach your user ID to the DB2 instance which in your case is db2 using the below command

    db2> Attach to db2 user ID3457 using password

    Let me know if that worked,

    Thanks
    Sreeharsha