User Profile

Collapse

Profile Sidebar

Collapse
raimee
raimee
Last Activity: Mar 10 '08, 07:11 PM
Joined: Sep 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • raimee
    replied to Execute runstats in a stored procedure
    in DB2
    I use a shell script to accomplish what you want. You'll have to modify a bit
    for you environment.

    #!/usr/bin/ksh

    ############### ############### ############### #######

    DBNAME="DBNAME"
    TABSCHEMA="MYSC HEMA"

    db2 activate db $DBNAME
    export DB2DBDFT=$DBNAM E

    echo "Running... "

    db2 connect to $DBNAME user user using...
    See more | Go to post

      Leave a comment:

    • raimee
      replied to Scheduling a DB2 command to run
      in DB2
      If you use the graphic tools, have a look at the Task Center. You can schedule
      'commands' there and then use the Journal to monitor status....
      See more | Go to post

        Leave a comment:

      • raimee
        replied to Stored Procedure
        in DB2
        Hi Amit,

        check the system catalog tables. You should find what you're looking for there.

        ex.

        db2 "select * from SYSCAT.PROCEDUR ES where PROCSCHEMA='xxx xx'"
        See more | Go to post

          Leave a comment:

        No activity results to display
        Show More
        Working...