Hi, folks.

Sorry about this - I have been R'ing all TFM's I can find, but am just
getting more frustrated.

Background:

db2 UDB 8.1 on Windows.

I'm quite new to db2, but have several years Oracle experience.

I'm attempting to resolve a locking issue by isolating a table in its
own tablespace, and setting the MAXROWS parameter to ensure that one
row is written per page. I intended to quiesce or stop the db, make
the change, and reorg the tablespace afterwards.

This measure is being taken on the advice of a more senior DBA who has
apparently resolved the issue in his environment by taking this step.

I am just trying to alter the tablespace, by using

ALTER TABLESPACE <db_name>.<tablespace_name> MAXROWS 1

But I'm having syntax issues. It barks back at me that I need to
supply a PREFETCHSIZE parameter as well:

DB21034E  The command was processed as an SQL statement because it was
not a
valid Command Line Processor command.  During SQL processing it
returned:
SQL0104N  An unexpected token "maxrows" was found following
"tablespace
TSCHN002".  Expected tokens may include:  "PREFETCHSIZE".
SQLSTATE=42601

I have been poring over the ALTER TABLESPACE syntax diagrams on the
boulder.ibm.com site, and am baffled as to why this is not being
accepted. The MAXROWS parameter is advertised as a valid parameter in
ALTER TABLESPACE. Do I need to include some more comprehensive
parameter list for the ALTER TABLESPACE, or can I not simply alter one
parameter on its own?

Thanks,

BD