Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    15

    Unanswered: perl script trying to update monitor switches

    1. Select,Insert and update works on my perl script.
    2. When i try to do reset monitor all I am getting the following error message
    "<!-- warning: DBD:B2::db do failed: [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "monitor" was found following "reset ".
    Expected tokens may include: "JOIN «joined_table»". SQLSTATE=42601 -->
    "

    Any idea

    Regards
    Rajesh Krishnan

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Only SQL statements (DML, DDL or DCL) can be passed to the DBD interface; no DB2 commands like "monitor" or "import" etc.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Oct 2006
    Posts
    15
    So what do i need to update monitor switches. Do i need to build ksh to it

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    To do it from within perl, just use commands like
    $cmd = "monitor ...."; # or similar
    $mon_output = `db2 $command`;
    print $mon_output; # or whatever
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  5. #5
    Join Date
    Oct 2006
    Posts
    15
    Thanks for your timely response

Posting Permissions

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