I'm trying to use the new SQL based snapshot functions to get the
tablespace containers (SNAPSHOT_CONTAINER). On systems with
approximately 1400 tablespaces, the query runs for about 40 minutes
before falling over (see below). If I perform the same function using
API's, it takes less than a minute and works great.
Any ideas why the SQL function is performing so poorly? I'd like to stay
in Java, if possible. I'm running on Solaris with FP2, but have seen
this same behavior with AIX.
Thanks for any help,
Here's the error when the SQL finally fails:
$ db2 "select ...