Thanks, Angela. I'll pass that along to my customer. It may be a W2K3 server,
so they may be stuck at 6.3.
STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | Stephen.Stackwick AT
icfi DOT com | icfi.com
ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 |
410.539.1135 (o)
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Angela Robertson
> Sent: Friday, August 23, 2013 5:54 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] queryoptimization - what is it?
>
> Hi Stephen,
>
> QUERYOPTimization is an undocumented option. In general, it is only to be used
> when service suggests it as a way to turn off query optimization as a
> workaround, if query related issues occur. The option continues to work in
> the
> latest release, but it should not be needed. Upgrading to the latest release
> is the
> suggested solution to these problems. If it is found to be needed in the
> latest
> release, a PMR should be opened. The default is that the option is not used
> and
> query optimization is turned on. Query optimization provides better
> performance which becomes more noticeable as the number of number of
> databases involved increases.
>
> ----------------------------------------------------------------
> Angela Robertson
> IBM Software Group
> Durham, NC 27703
> aprobert AT us.ibm DOT com
> ----------------------------------------------------------------
>
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 08/22/2013
> 10:43:00 AM:
>
> > "Stackwick, Stephen" <Stephen.Stackwick AT ICFI DOT COM> Sent by: "ADSM:
> > Dist
> > Stor Manager" <ADSM-L AT vm.marist DOT edu>
> >
> > 08/22/2013 10:43 AM
> >
> > Please respond to
> > "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
> >
> > To
> >
> > ADSM-L AT vm.marist DOT edu,
> >
> > cc
> >
> > Subject
> >
> > [ADSM-L] queryoptimization - what is it?
> >
> > We have 6.3 SQL TDPs that were getting:
> >
> > ACO5422E CSqlApi::GetSqlDatabaseInfoOpt3
> >
> > errors, even if we excluded the databases causing the messages.
> > Short story, the backup still looks like it fails, even though the
> > databases we care about are getting backed up fine. Following Del's
> > recommendation on this list, we set QUERYOPTIMIZATION 0 in the
> > tdpsql.cfg file, and the messages go away.
> >
> > My customer (and I) would like to know what this option does. I
> > haven't been able to find it mentioned in the manual.
> >
> > Thanks!
> >
> > STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) |
> > Stephen.Stackwick AT icfi DOT com<mailto:sstackwick AT icfi DOT com> |
> > icfi.com<
> > http://www.icfi.com/> ICF INTERNATIONAL | 410 E. Pratt Street Suite
> > 2214, Baltimore, MD
> > 21202 | 410.539.1135 (o)
> >
|
