Incredible amount of sessions

[dhipp]

All,

I have a TDP node that logs about 200 sessions for 4 databases on one node. The maxnump=3 and the keepmount=no. Is this normal?

[moon-buddy]

Nope - not normal.

Are these sessions on IdleW?

If these are, look for bottlenecks like full diskpool and migrations not happening, or no scratch tapes.

[dhipp]

They start, and immediately end, repeat, repeat, etc... about 300 times. In example,

06/27/2012 16:14:36 ANR0403I Session 1660 ended for node PINATUBO-DB (TDPO
Linux86-64). (SESSION: 1660)
06/27/2012 16:14:36 ANR0406I Session 1661 started for node PINATUBO-DB (TDPO
Linux86-64) (Tcp/Ip pinatubo.uchicago.edu(31191)).
(SESSION: 1661)
06/27/2012 16:14:37 ANR0403I Session 1661 ended for node PINATUBO-DB (TDPO
Linux86-64). (SESSION: 1661)
06/27/2012 16:14:37 ANR0406I Session 1662 started for node PINATUBO-DB (TDPO
Linux86-64) (Tcp/Ip pinatubo.uchicago.edu(31192)).
(SESSION: 1662)
06/27/2012 16:14:37 ANR0403I Session 1662 ended for node PINATUBO-DB (TDPO
Linux86-64). (SESSION: 1662)
06/27/2012 16:14:37 ANR0406I Session 1663 started for node PINATUBO-DB (TDPO
Linux86-64) (Tcp/Ip pinatubo.uchicago.edu(31193)).
(SESSION: 1663)
06/27/2012 16:14:37 ANR0403I Session 1663 ended for node PINATUBO-DB (TDPO
Linux86-64). (SESSION: 1663)
06/27/2012 16:14:37 ANR0406I Session 1664 started for node PINATUBO-DB (TDPO
Linux86-64) (Tcp/Ip pinatubo.uchicago.edu(31194)).
(SESSION: 1664)
06/27/2012 16:14:37 ANR0403I Session 1664 ended for node PINATUBO-DB (TDPO
Linux86-64). (SESSION: 1664)
06/27/2012 16:14:37 ANR0406I Session 1665 started for node PINATUBO-DB (TDPO
Linux86-64) (Tcp/Ip pinatubo.uchicago.edu(31195)).
(SESSION: 1665)

[moon-buddy]

You were not clear at first.

You are looking at the actlog. On the command line, if you do 'q session' what do you see? any session/s running from those nodes you are seeing from the actlog?

This seems that the node is in 'polling' mode. But frequency of 'query' is what's bothering me.

What version of TDP for Oracle are you running?

[dhipp]

Node Name: PINATUBO-DB
Platform: TDPO Linux86-64
Client OS Level: 2.6.18-308.8.1.el5
Client Version: Version 6, release 3, level 0.0

[moon-buddy]

What does 'q session' say?

[dhipp]

q sess is fine. Says three sessions (matching the maxnump), it's more watching the console go by and the session numbers incrementing by 1 300 times. Seems to only happen on TDP for database nodes

[cwilloug]

This is "normal" for TDP nodes. Unlike a regular backup client, that starts a session (or two) and then sends the backup to your TSM server/disk/tape then disconnects, TDP will start a session, send one file, end that session, start a new session for the next file, and repeat 300+ times. This is what you are seeing in your activity log.