Re: Select with TSM 6.1

Thanks Richard, that did the trick. Very good detective work and much appreciated. Joerg Pohlmann 250-245-9863

Re: Select with TSM 6.1

Thanks for the detail numbers. I would have liked to have had you follow through with the computational suggestions I made in my reply. Whereas the DB table values are integers, integer math rules obviously result in the 0 output. So, what happens when you implement parentheses and explicit decima

Re: Select with TSM 6.1

Good point - here are the details from the two tables: tsm: VISTA1>select used_db_space_mb*100/free_space_mb from db Unnamed[1] 0 tsm: VISTA1>select used_space_mb*100/free_space_mb from log Unnamed[1] - 0.02

Re: Select with TSM 6.1

Suggestions: Include the involved values in your posting so we can gauge how the math comes out. It's healthiest to always use parentheses in multi-function computations, to avoid ambiguity and erroneous results. When you go for decimal results, habitually employ decimal constants (100.0), for bot

Select with TSM 6.1

I am trying to get an understanding on percent utilization of log and database with TSM 6.1. I always get zero output from the db table whereas the log table gives me a correct result. Any ideas are appreciated: tsm: VISTA1>select used_db_space_mb*100/free_space_mb from db Unnamed[1]