DB2 Administrative SQL Cookbook: Finding Tables in a Specific Tablespace, Without RI

You may also like...

2 Responses

  1. Isaac Munoz says:

    Hi Ember, thanks for sharing the query… if your tablespace is DMS why don’t you just convert it to large (alter tablespace … convert to large) ??. You can do it without issues and don’t worry about ADM6104W on db2diag.log (we’ve converted several without rebuilding the indexes and yet we haven’t got any errors). Hope this helps. Regards

    • Ember Crooks says:

      Good point. If regular to large is the only goal, that works. In this case, I’m also dealing with tablespaces that are not reclaimable, so I need to accomplish that conversion as well.

Leave a Reply

Your email address will not be published. Required fields are marked *