Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Cool Unanswered: Error inserting the tables

    I have created a table in my database ... i had also created a user and provided the access for "insert , update, delete'.

    Now if the user try to insert data using a DB2 client ..it is throwing an error as

    Query :

    INSERT INTO ITMUSER.PM_MASTER_RAW_COPY VALUES('C_WP1xL_S01xPS_01xPC_01xaP_TEST','2010-09-03 05:00:00.077','WT','C_WP1xL_S01xPS_01xPC_01x','PAC ','1.1009E+15',0,'NULL','NULL','HVAC')

    Error :

    DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0551N "GEMS_ADMIN" does not have the privilege to perform operation "EXECUTE" on object "NULLID.SQLC2E06". SQLSTATE=42501


    As per this error ...i have checked the privilages, the required privilage is available.

    if with the same user im trying to insert it from the Db2 Server itself , it is happening.. no error faced.

    help me how to rectify this .

  2. #2
    Join Date
    Oct 2007
    Posts
    246
    2. If the DB2 utility programs need to be rebound to the database, the
    database administrator can accomplish this by issuing one of the
    following CLP command from the bnd subdirectory of the instance,
    while connected to the database:
    * "DB2 bind @db2ubind.lst blocking all grant public" for the DB2
    utilities.
    * "DB2 bind @db2cli.lst blocking all grant public" for CLI.

    run the above in client


    To grant EXECUTE privilege on a package use the GRANT statement, for
    example: GRANT EXECUTE ON PACKAGE NULLID.SYSH200 TO PUBLIC.

    regds
    paul

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Hey Mathew..

    Thanks a lot buddy its working....

  4. #4
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    hey this error came again with another package name..

    i again execute the same command and granted the permisiion.

    my question is -- why it is comin only for that user and not for other ??
    why in every client it shows different package ??

    help me!

Posting Permissions

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