Default Allowed Access for RUNSTATS?

[Igge SYSteam]

We are using UDB 8.2 on Windows.
With RUNSTATS you can specify ALLOW READ or WRITE ACCESS. But this is
optional. What if you don't specify any of this? What's the default? I
can find that information in the manual. Does anybody know?

[Knut Stolze]

Igge SYSteam wrote:

We are using UDB 8.2 on Windows.
With RUNSTATS you can specify ALLOW READ or WRITE ACCESS. But this is
optional. What if you don't specify any of this? What's the default? I
can find that information in the manual. Does anybody know?

ALLOW WRITE ACCESS is the default.

http://publib.boulder.ibm.com/infoce...n/r0006726.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Igge SYSteam]

Knut Stolze wrote:

Igge SYSteam wrote:

We are using UDB 8.2 on Windows.
With RUNSTATS you can specify ALLOW READ or WRITE ACCESS. But this is
optional. What if you don't specify any of this? What's the default? I
can find that information in the manual. Does anybody know?

ALLOW WRITE ACCESS is the default.

http://publib.boulder.ibm.com/infoce...n/r0006726.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Ok, so it was me who haven't learned enogh about reading syntax
diagram. Thanks for pointing that out to me. I'm used to find "This is
the default" in the Command parameters section.

[Knut Stolze]

Igge SYSteam wrote:

http://publib.boulder.ibm.com/infoce...n/r0006726.htm

>
Ok, so it was me who haven't learned enogh about reading syntax
diagram. Thanks for pointing that out to me. I'm used to find "This is
the default" in the Command parameters section.

In the DB2 manuals, you'll always have the default "above the line". Once
you remember that, it's quite easy. Besides, searching through pages of
text is not nearly as effective as just looking at the diagram. ;-)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany