tag:blogger.com,1999:blog-13518440.post928273489087013907..comments2023-12-12T04:39:52.103-08:00Comments on TSMAdmin: Archive ReportChad Smallhttp://www.blogger.com/profile/02637281120881655693noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-13518440.post-55578935062261100572013-10-24T16:01:53.833-07:002013-10-24T16:01:53.833-07:00That's what I am wanting to do, but I need a c...That's what I am wanting to do, but I need a command similar to the table and column listing select that would work in DB2. Chad Smallhttps://www.blogger.com/profile/02637281120881655693noreply@blogger.comtag:blogger.com,1999:blog-13518440.post-69975976152710040142013-10-23T18:15:39.368-07:002013-10-23T18:15:39.368-07:00Have you thought about squirting your query direct...Have you thought about squirting your query direct into the DB2 back end? You could use more advanced SQL then which may go faster. You may find more useful info there too. I've done it before to drill down to get data quantities for active/inactive/deleted backup data which I couldn't find through the normal TSM views, but it's been a while. Anonymoushttps://www.blogger.com/profile/12153387785972149351noreply@blogger.com