Previous Topic

Next Topic

Book Contents

pfmqadmin command

pfmqadmin creates tables for PFMQ and specifies their locations.

  1. Before you create the PFMQ tables, you must do one of the following:
    • Create an Oracle user, using Oracle Enterprise Manager Console, or
    • Drop and recreate the Oracle user, run the pfmqadmin command with the following arguments:

      pfmqadmin setup dbuser system [connectstring] [pfmquser]

    When prompted, enter the password for the database SYS user and the pfmquser.

  2. Create PFMQ tables and specify locations:

    pfmqadmin setup dbusertable [AdminDBUID] [connectstring]

    pfmqadmin config queueinfostore [AdminDBUID] [connectstring]

    pfmqadmin config defaultmessagestore [AdminDBUID] [connectstring]

    When prompted, enter the password for the pfmq database admin.

Arguments

Send Feedback