Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2010
    Posts
    56

    Unanswered: how to revent clients connect to database using CLP

    Hi,
    I'm looking for a way to prevent clients connect to database using CLP .
    I want to allow them to connect only through a particular application.
    Is it possible to define a trigger like after logon on oracle ?
    Is there another way to do this?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You might be able to use Workload Manager for that.

  3. #3
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    you can write a script in shell / awk which will find out the applications which are connected to the system using CLP and then force / terminate them off. Schedule that script to run after an interval suitable for your environment.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Starting in DB2 9.7 Fixpack 3, you can specify a stored procedure in the database configuration that will be executed each time an application connects to the database. You could probably put some code in the connect stored procedure that will do what you want.
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

    Make certain that you Grant EXECUTE privilege to PUBLIC for the connect procedure that you specify.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Oct 2010
    Posts
    56

    Tks , i will try it

    Thank you about the solution, I wil try it .
    We are thinking about upgrade the db to v9.7 (from 9.5) , so it will be usefull for us.

Posting Permissions

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