Differences
This shows you the differences between the selected revision and the current version of the page.
| wiki:sysmaster 2021/04/21 11:59 | wiki:sysmaster 2021/04/22 13:28 current | ||
|---|---|---|---|
| Line 361: | Line 361: | ||
| order by 1 | order by 1 | ||
| + | |||
| ===== List all the tables in the temporary dbspaces by session ===== | ===== List all the tables in the temporary dbspaces by session ===== | ||
| Line 371: | Line 372: | ||
| t2.dbsname [1,18] AS database, | t2.dbsname [1,18] AS database, | ||
| t2.tabname [1,22] AS table, | t2.tabname [1,22] AS table, | ||
| - | t3,name [1,10] AS dbspace, | + | t3.name [1,10] AS dbspace, |
| (CURRENT - DBINFO('utc_to_datetime', ti_created)) :: INTERVAL DAY(4) TO SECOND AS life_time, | (CURRENT - DBINFO('utc_to_datetime', ti_created)) :: INTERVAL DAY(4) TO SECOND AS life_time, | ||
| (ti_nptotal * ti_pagesize/1024) :: INT AS size_kb | (ti_nptotal * ti_pagesize/1024) :: INT AS size_kb | ||
| Line 394: | Line 395: | ||
| ORDER BY 6 DESC, 5 DESC; | ORDER BY 6 DESC, 5 DESC; | ||
| - | If you get | ||
| - | |||
| - | 9635: An attempt has failed to convert an opaque type into another type without a cast function. | ||
| - | |||
| - | Just remove the order by | ||
