Archives of the TeradataForum

Message Posted: Mon, 20 Jun 2005 @ 18:36:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Another way to find mini cylinder packs is to run a query against the software event log. Below is a query. You don't really need the like '514%', but this gives a little more information about the reason to for the mini-cylinder packs.

     select thedate
              ,sum (case when text like '5141%' then 1
                        else 0
                        end) as  E5141_Anticipation
              ,sum (case when text like '5142%' then 1
                        else 0
                        end) as E5142_Tasks_Waiting
              ,sum (case when text like '5143%' then 1
                        else 0
                        end) as E5143
     from dbc.software_event_log
     where text like '%mini-cylinder%' and text like '514%'
     group by 1
     order by 1 desc

I recommend setting up Teradata Manager alerts to notify when minicyl packs are happening.

You can also monitor free cylinders by VPROC by running a Teradata Manager Query. Investigate...Space Usage....Cylinders by VPRoc from drop down menus. If free cylinders are below 5%, you should really consider running pack disk to avoid getting mini-cyl packs. However, the threshold can vary depending on system usage: load strategies and spool usage.

I would also recommend setting up your own alert for low free cylinders as I don't believe this alert is part of out of the box Teradata Manager Alerts.

Thanks,

Bob Diehl

	<Prev	Next>		<<First	<Prev	Next>	Last>>