473,383 Members | 1,795 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Reorg , Runstat and Stored Proc

Once the REORG and RUNSTAT on db2 database tables and indexes is executed, do we need to rebind the stored procedures to attain the performance improvement ?
If required, is there any db2 command which can be used to do the same?
Mar 27 '07 #1
0 2964

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Mark Barinstein | last post by:
Hello. I am trying to call sqlureot from stored procedure. I use VC++ 6.0. Here is the c - code of my routine and DDL for creating my procedure. --- bisp.c sample code --- #include <sqlenv.h>...
27
by: Raquel | last post by:
This question if for UDB on LUW. Suppose I take regular database backups of my database Monday: database backup <ts1> Tuesday: Tablespace reorged and imagecopied <ts2> Friday: database...
0
by: Dave Sisk | last post by:
I've created a system or external trigger on an AS/400 file a.k.a DB2 table. (Note this is an external trigger defined with the ADDPFTRG CL command, not a SQL trigger defined with the CREATE...
14
by: Roy | last post by:
Apologies for the cross-post, but this truly is a two-sided question. Given the option of creating Looping statements within a stored proc of sql server or in the code-behind of an .net webpage,...
3
by: kartic_s | last post by:
he brief explanation of the problem is, After DB2 maintenance window performance has gone down, it takes some hours to retrieve the data. We have provided some table spaces to Reorg/Runstat...
0
by: Ah Yu (Quentin) | last post by:
Hi, Does anyone know how to run a reorg job with limited impact to system performance? When my reorg job is running, I cannot see "get utilities" give result entry related to the reorg job and...
1
by: Patrick Finnegan | last post by:
Running DB2 9.1 on Redhat Linux 4.1. Storage management indicates that the pages stored in a file based SMS container occupy 7 gig of the total space allocated which is 50gig. I wrote a script...
0
by: mirandacascade | last post by:
Questions toward the bottom of the post. Situation is this: 1) Access 97 2) SQL Server 2000 3) The Access app: a) sets up pass-thru query b) .SQL property of querydef is a string, the...
1
by: uwcssa | last post by:
hi all my runstat runs too slow. Moreover, it is not using lots of available resources (cpu is 94% idle, iostat shows really small intermittened IO) is there a way to speed up runstat? or is...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.