Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2014
    Posts
    4

    Red face Unanswered: Scripts SQL jobs. help needed

    Hi Friends,

    I am new to db2. I have some sql queries which i need to run daily and pull out the report and send it to some stake holders.

    The above task is more time consuming. It will be better if some one helps me to create scripts.


    One of my query is:

    select TBSP_NAME,TBSP_TYPE,TBSP_STATE,TBSP_PAGE_SIZE,TBSP _TOTAL_SIZE_KB,TBSP_UTILIZATION_PERCENT,DATA_HIT_R ATIO_PERCENT
    from sysibmadm.MON_TBSP_UTILIZATION
    order by TBSP_NAME;

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    What is your operating system (the one where you will run the report and send the email containing report output) ?
    What is your db2-version, db2-server version+fixpack ?
    What kind of scripting are you most familiar with ?

Tags for this Thread

Posting Permissions

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