Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: command center experts

    I am connected to a db2 database ver 8.1 on AIX 5.1 server using my personal id 'udbuser'. I want to 'su' to different user 'batchuser' to run some db2 commands and execute few scripts using command center. How do I accomplish this?

    I can very well do this using telnet. but want to do same using command center.

    Thanks,
    toby

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow Connect reset - then conncet

    Hi - try this:


    connect reset;

    connect to <yourdb> user <youruser> using <yourpassword>;


    But remeber that you can only be connected as one user at the time.

    Hope this helps
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Sep 2003
    Posts
    63
    Is there any other way to do this in control center other than connect database command.

  4. #4
    Join Date
    Apr 2004
    Location
    Shenzhen
    Posts
    8
    and you must confirm the user 'batchuser' have the proper right in the database .

  5. #5
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Question

    No I don't think there is any other way.

    But isn't connect reset/connect adequate?

    Cheers
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

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