V6 Tables

[TSMCON]

Hi

Our engineering team have installed TSM v6. Running fine, but i noted that many of the tables that existed in v5 (drmedia, summary etc) no longer appear when i 'select tabname from sysibm.tables'. They don't exist, but i can still do selects from them.

select * from drmedia - works fine
select volume_name, state from drmedia - works fine
select volume_name, state from drmedia order by 2 - fails
'ANR2944E The reference 'ORDER' is an unknown SQL scalar function name'

Similar for the summary table, for which i have many existing scripts written in v5.5.3

Am i missing something? I've read the technical guide, but no mention that these tables no longer exist

[ChrisRees]

Hi

I know this post was a long time ago but I thought you might be interested in this


I'm getting the same error on 6.2.0 and it appears to be a bug.

http://www-01.ibm.com/support/docvie...id=swg1IC67415

Cheers