Looking for syntax help with ALTER TABLESPACE

[BD]

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_nameMAXROWS 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

[BD]

Yes, DB2 for zOS and DB2 for LUW (Linux/Unix/Windows) don't have all options

in common.

Thanks. Yep, I see neither PCTFREE nor MAXROWS as a tablespace-level
option under LUW. So long as I know, I guess.

[Mark A]

"BD" <ro*********@gmail.comwrote in message
news:77**********************************@i7g2000p rf.googlegroups.com...

Thanks. Yep, I see neither PCTFREE nor MAXROWS as a tablespace-level
option under LUW. So long as I know, I guess.

PCTFREE is at the table level in DB2 for LUW. That is one reason why most
people use one table per tablespace in DB2 for z/OS, but put many tables in
the same tablespace in DB2 for LUW (but only if all the tables in that
tablespace will be in the same bufferpool).

[BD]

On Jan 29, 7:30*pm, "Mark A" <[e-mail]:

"BD" <[e-mail] in message

news:77**********************************@i7g2000p rf.googlegroups.com...

Thanks. Yep, I see neither PCTFREE nor MAXROWS as a tablespace-level
option under LUW. *So long as I know, I guess.

PCTFREE is at the table level in DB2 for LUW. That is one reason why most
people use one table per tablespace in DB2 for z/OS, but put many tables in
the same tablespace in DB2 for LUW (but only if all the tables in that
tablespace will be in the same bufferpool).

It's so nice, developing one one platform, for a deployment that's
sitting on another. Oh joy, oh bliss... ;-)