Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2010
    Posts
    5

    Question Unanswered: DB2 backup problem on Vista

    Hi Folks,

    How to do a database backup in DB2 in Vista?

    Here's my experiment:
    Whenever I issued this command (logining in Vista as Administrator):

    Code:
    restore database myDB from D: taken at 20081013134446
    the command line processor return the following error message:

    Code:
    SQL1092N  "ADMINISTRATOR" does not have the authority 
    to perform the requested command.  SQLSTATE=00000
    So, How can I solve this problem?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Do not use ADMINISTRATOR do do the operation. Use the instance owner.

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Alternatively, you could add Administrator to the group DB2ADMNS

  4. #4
    Join Date
    Apr 2010
    Posts
    5
    So, How to switch to the DB user ?
    (I've tried to login by the automatically created db2admin WINDOWS account but doesn't work for me)

    How to add Administrator to DB2ADMNS group, It is an ordinary WINDOWS Group ??

    Thanks.

  5. #5
    Join Date
    Apr 2010
    Posts
    5
    Any replies guyz ??

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What doesn't work when you use the db2admin account?

    Andy

  7. #7
    Join Date
    Apr 2010
    Posts
    5
    When I issued the restore command, It returned the same error message:

    Code:
    SQL1092N  "DB2ADMIN" does not have the authority  to perform 
    the requested command.  SQLSTATE=00000

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What groups is db2admin in?

    What is the output of "db2 get dbm cfg"?

    Andy

  9. #9
    Join Date
    Apr 2010
    Posts
    5
    What is the output of "db2 get dbm cfg"?
    Code:
    C:\Program Files\IBM\SQLLIB\BIN>db2 get dbm cfg
    
              Database Manager Configuration
    
         Node type = Enterprise Server Edition with local and remote clients
    
     Database manager configuration release level            = 0x0a00
    
     Maximum total of files open               (MAXTOTFILOP) = 16000
     CPU speed (millisec/instruction)             (CPUSPEED) = 3.621306e-007
     Communications bandwidth (MB/sec)      (COMM_BANDWIDTH) = 1.000000e+002
    
     Max number of concurrently active databases     (NUMDB) = 8
     Data Links support                          (DATALINKS) = NO
     Federated Database System Support           (FEDERATED) = NO
     Transaction processor monitor name        (TP_MON_NAME) =
    
     Default charge-back account           (DFT_ACCOUNT_STR) =
    
     Java Development Kit installation path       (JDK_PATH) = C:\PROGRA~1\IBM\SQLLIB\java\jdk
    
     Diagnostic error capture level              (DIAGLEVEL) = 3
     Notify Level                              (NOTIFYLEVEL) = 3
     Diagnostic data directory path               (DIAGPATH) =
    
     Default database monitor switches
       Buffer pool                         (DFT_MON_BUFPOOL) = OFF
       Lock                                   (DFT_MON_LOCK) = OFF
       Sort                                   (DFT_MON_SORT) = OFF
       Statement                              (DFT_MON_STMT) = OFF
       Table                                 (DFT_MON_TABLE) = OFF
       Timestamp                         (DFT_MON_TIMESTAMP) = ON
       Unit of work                            (DFT_MON_UOW) = OFF
     Monitor health of instance and databases   (HEALTH_MON) = ON
    
     SYSADM group name                        (SYSADM_GROUP) =
     SYSCTRL group name                      (SYSCTRL_GROUP) =
     SYSMAINT group name                    (SYSMAINT_GROUP) =
     SYSMON group name                        (SYSMON_GROUP) =
    
     Client Userid-Password Plugin          (CLNT_PW_PLUGIN) =
     Client Kerberos Plugin                (CLNT_KRB_PLUGIN) = IBMkrb5
     Group Plugin                             (GROUP_PLUGIN) =
     GSS Plugin for Local Authorization    (LOCAL_GSSPLUGIN) =
     Server Plugin Mode                    (SRV_PLUGIN_MODE) = UNFENCED
     Server List of GSS Plugins      (SRVCON_GSSPLUGIN_LIST) =
     Server Userid-Password Plugin        (SRVCON_PW_PLUGIN) =
     Server Connection Authentication          (SRVCON_AUTH) = NOT_SPECIFIED
     Database manager authentication        (AUTHENTICATION) = SERVER
     Cataloging allowed without authority   (CATALOG_NOAUTH) = NO
     Trust all clients                      (TRUST_ALLCLNTS) = YES
     Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT
     Bypass federated authentication            (FED_NOAUTH) = NO
    
     Default database path                       (DFTDBPATH) = C:
    
     Database monitor heap size (4KB)          (MON_HEAP_SZ) = 66
     Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 512
     Audit buffer size (4KB)                  (AUDIT_BUF_SZ) = 0
     Size of instance shared memory (4KB)  (INSTANCE_MEMORY) = AUTOMATIC
     Backup buffer default size (4KB)            (BACKBUFSZ) = 1024
     Restore buffer default size (4KB)           (RESTBUFSZ) = 1024
    
     Agent stack size                       (AGENT_STACK_SZ) = 16
     Minimum committed private memory (4KB)   (MIN_PRIV_MEM) = 32
     Private memory threshold (4KB)        (PRIV_MEM_THRESH) = 20000
    
     Sort heap threshold (4KB)                  (SHEAPTHRES) = 10000
    
     Directory cache support                     (DIR_CACHE) = YES
    
     Application support layer heap size (4KB)   (ASLHEAPSZ) = 15
     Max requester I/O block size (bytes)         (RQRIOBLK) = 32767
     DOS requester I/O block size (bytes)     (DOS_RQRIOBLK) = 4096
     Query heap size (4KB)                   (QUERY_HEAP_SZ) = 1000
    
     Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
    
     Priority of agents                           (AGENTPRI) = SYSTEM
     Max number of existing agents               (MAXAGENTS) = 400
     Agent pool size                        (NUM_POOLAGENTS) = 200(calculated)
     Initial number of agents in pool       (NUM_INITAGENTS) = 0
     Max number of coordinating agents     (MAX_COORDAGENTS) = (MAXAGENTS - NUM_INITAGENTS)
     Max no. of concurrent coordinating agents  (MAXCAGENTS) = MAX_COORDAGENTS
     Max number of client connections      (MAX_CONNECTIONS) = MAX_COORDAGENTS
    
     Keep fenced process                        (KEEPFENCED) = YES
     Number of pooled fenced processes         (FENCED_POOL) = MAX_COORDAGENTS
     Initial number of fenced processes     (NUM_INITFENCED) = 0
    
     Index re-creation time and redo index build  (INDEXREC) = RESTART
    
     Transaction manager database name         (TM_DATABASE) = 1ST_CONN
     Transaction resync interval (sec)     (RESYNC_INTERVAL) = 180
    
     SPM name                                     (SPM_NAME) = COMPU10
     SPM log size                          (SPM_LOG_FILE_SZ) = 256
     SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
     SPM log path                             (SPM_LOG_PATH) =
    
     NetBIOS Workstation name                        (NNAME) =
    
     TCP/IP Service name                          (SVCENAME) = db2c_DB2
     Discovery mode                               (DISCOVER) = SEARCH
     Discover server instance                (DISCOVER_INST) = ENABLE
    
     Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
     Enable intra-partition parallelism     (INTRA_PARALLEL) = NO
    
     No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 4096
     Number of FCM request blocks              (FCM_NUM_RQB) = AUTOMATIC
     Number of FCM connection entries      (FCM_NUM_CONNECT) = AUTOMATIC
     Number of FCM message anchors         (FCM_NUM_ANCHORS) = AUTOMATIC
    
     Node connection elapse time (sec)         (CONN_ELAPSE) = 10
     Max number of node connection retries (MAX_CONNRETRIES) = 5
     Max time difference between nodes (min) (MAX_TIME_DIFF) = 60
    
     db2start/db2stop timeout (min)        (START_STOP_TIME) = 10

  10. #10
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Run this in the DB2 command window:

    db2 update dbm cfg using sysadm_group db2admns

    then restart the instance. It might be worth your while to check the manual as well: Adding your user ID to the DB2ADMNS and DB2USERS user groups (Windows) - IBM DB2 9.7 for Linux, UNIX, and Windows

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •