Commands --> Command Line Processor (CLP) Hope this helps [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Gert van der Kooij [ip] => gk-ibm-db2@xs4a [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> runstats - IBM DB2

runstats - IBM DB2

can someone tell me how to do runstats on db2 v8.1 windows ? i try to this comand on db2 command window but it tells me the command not recorgnized. thanks...

  1. #1

    Default runstats

    can someone tell me how to do runstats on db2 v8.1 windows ? i try to
    this comand on db2 command window but it tells me the command not
    recorgnized. thanks
    xixi Guest

  2. #2

    Default Re: runstats

    type db2cmd to get a real DB2 command window and in the windows launched
    from there (should be titled DB2 CLP) type DB2 ? RUNSTATS for syntax.

    xixi wrote:
    > can someone tell me how to do runstats on db2 v8.1 windows ? i try to
    > this comand on db2 command window but it tells me the command not
    > recorgnized. thanks
    Blair Kenneth Adamache Guest

  3. #3

    Default Re: runstats

    In article <c0f33a17.0306301202.6a79d4cfposting.google.com >,
    [email]dai_xi[/email] says...
    > can someone tell me how to do runstats on db2 v8.1 windows ? i try to
    > this comand on db2 command window but it tells me the command not
    > recorgnized. thanks
    >
    First connect to the database, then issue the 'db2 runstats on table
    <tabscheam>.<tabname> <various options ..>' command.

    Check the DB2 Command Reference (PDF and pre V8 html) or when using
    the V8 html doc:
    Reference --> Commands --> Command Line Processor (CLP)

    Hope this helps
    Gert van der Kooij Guest

  4. #4

    Default runstats

    can anyone tell me how to do runstats programmatically? i just create
    new index for a lot of tables and figure might need to do a runstats,
    but it takes time to do manully. thanks
    xixi Guest

  5. #5

    Default Re: runstats

    "xixi" <dai_xi> wrote in message
    news:c0f33a17.0307011139.67ba008fposting.google.c om...
    > can anyone tell me how to do runstats programmatically? i just create
    > new index for a lot of tables and figure might need to do a runstats,
    > but it takes time to do manully. thanks
    Do you know how to submit DB2 command jobs with scripts? Check out the DB2
    Command Reference Manual.


    Mark A Guest

  6. #6

    Default runstats

    hi, i am using db2 udb v8.1. our application needs to dynamically
    generate table on run time, then insert data, then using this table to
    do select query, so i think might be create index together when create
    table, will this help performance? After create index, will access
    path updated to recorgnize the new index, do i need to do runstats?
    since this is on run time, how do i do runstats? thanks
    xixi Guest

  7. #7

    Default Re: runstats



    xixi wrote:
    >hi, i am using db2 udb v8.1. our application needs to dynamically
    >generate table on run time, then insert data, then using this table to
    >do select query, so i think might be create index together when create
    >table, will this help performance?
    >
    depending on the query, runstats will help.
    >After create index, will access
    >path updated to recorgnize the new index,
    >
    yes.
    > do i need to do runstats?
    >
    no, but runstats may improve perf.
    >
    >since this is on run time, how do i do runstats? thanks
    >
    there are api and script?
    Also, you should consider "cooking" the statistics after creating the
    index, for example:
    - creating index, table, etc.
    - run your inserts, in development
    - runstats yourself, by hand
    - run db2look against the target object in mimic mode
    - in production application, add the statistics updates from db2look
    into your application, after creating the index (no runstats is run at
    runtime).

    sharpe@us.ibm.com Guest

  8. #8

    Default Re: runstats


    Check the VOLATILE Option in Create table/Alter table ...

    Cheers
    Sathyaram

    Originally posted by XIXI
    > hi, i am using db2 udb v8.1. our application needs to dynamically
    > generate table on run time, then insert data, then using this table to
    > do select query, so i think might be create index together when create
    > table, will this help performance? After create index, will access
    > path updated to recorgnize the new index, do i need to do runstats?
    since this is on run time, how do i do runstats? thanks

    --
    DB2 discussion also at [url]http://www.dbforums.com/f8[/url]


    Posted via [url]http://dbforums.com[/url]
    sathyaram_s Guest

  9. #9

    Default Re: runstats

    See COLLECT STATISTICS in the create index command.

    PM


    PM \(pm3iinc-nospam\) Guest

  10. #10

    Default Re: runstats

    Is there a way to setup a stored procedure to do a runstats on a given table
    name?

    "Larry Menard" <lmenardca.ibm.com> wrote in message
    news:bdsp0c$ipj$1hanover.torolab.ibm.com...
    > Put all your runstats commands in a script.
    > --
    > Larry Menard
    > IBM Workstation Database (DB2) Performance Team
    > Defender of Geese and of All Things Natural
    >
    >
    > "xixi" <dai_xi> wrote in message
    > news:c0f33a17.0307011139.67ba008fposting.google.c om...
    > > can anyone tell me how to do runstats programmatically? i just create
    > > new index for a lot of tables and figure might need to do a runstats,
    > > but it takes time to do manully. thanks
    >
    >

    Patrick McMorris Guest

  11. #11

    Default Re: runstats

    Sure... write the SP in C, and in it call the sqlustat() API against the
    desired table. I believe somebody may have mentioned this earlier in this
    thread?
    --
    Larry Menard
    IBM Workstation Database (DB2) Performance Team
    Defender of Geese and of All Things Natural


    "Patrick McMorris" <pmcmorriANTI-SPAMcpcinc.ca> wrote in message
    news:raLMa.52084$Mc4.6423220news0.telusplanet.net ...
    > Is there a way to setup a stored procedure to do a runstats on a given
    table
    > name?
    >
    > "Larry Menard" <lmenardca.ibm.com> wrote in message
    > news:bdsp0c$ipj$1hanover.torolab.ibm.com...
    > > Put all your runstats commands in a script.
    > > --
    > > Larry Menard
    > > IBM Workstation Database (DB2) Performance Team
    > > Defender of Geese and of All Things Natural
    > >
    > >
    > > "xixi" <dai_xi> wrote in message
    > > news:c0f33a17.0307011139.67ba008fposting.google.c om...
    > > > can anyone tell me how to do runstats programmatically? i just create
    > > > new index for a lot of tables and figure might need to do a runstats,
    > > > but it takes time to do manully. thanks
    > >
    > >
    >
    >

    Larry Menard Guest

Similar Threads

  1. runstats - oracle
    By janagana in forum IBM DB2
    Replies: 5
    Last Post: August 23rd, 05:31 PM
  2. runstats and error code 930
    By Fan Ruo Xin in forum IBM DB2
    Replies: 3
    Last Post: August 15th, 12:31 AM
  3. runstats use all the CPUs?
    By Fan Ruo Xin in forum IBM DB2
    Replies: 2
    Last Post: July 26th, 12:22 AM
  4. runstats and embedded sql
    By Larry Menard in forum IBM DB2
    Replies: 2
    Last Post: July 9th, 11:32 PM
  5. Runstats issue
    By Kota in forum IBM DB2
    Replies: 3
    Last Post: July 7th, 12:50 PM

Bookmarks

Posting Permissions

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