Hello Marcel,

Yes, gathering with nsradmin the show session is a track but
is less easy to retrieve how session instance has been started,
its level, its group ....

Once you have the ssid, you can retrieve the group and all mediadb fields
you need.

Useful, for reporting, for knowing data flow between disk pools and tape pools
(clone and not-cloned pools). But not only.

Also useful for alarming (backup not completed yet at time x)
Without SSID, you cannot determine if it's a differential or full backup
that takes longer time and going out of backup window ...

and also to fix/bypass a bug present since adv_file has been introduced
that prevents you to monitor advfile usage correctly :
If you look at the 2 volumes created when you label an advfile
device (a writable and the readonly .RO one), you will probably notice
the amount of data written to the writable part of the volume
(the written media db field of the volume's record)
will NOT be deduced by the amout of data the nsrstage
may have moved away when the "writable volume" is busy writing.

sample :
volume ADVFSVOL. Querying mediadb :
mminfo -q volume=ADVFSVOL -r written
-> sample 10GB.

I launch a save to ADVFSVOL : save -s .....

During save, I purge all savesets from ADVFILE device :
        mminfo -q volume=ADVFSVOL.RO -r SSID,CLONEID > FILELIST
        nsrstage -v -m -B targetpool -S -F FILELIST

Save is expected to write 5GB to writable part of the volume.
>From a math point of view, 10GB -10GB +5GB should give 5GB unless ... :-)

IF Save does finish before nsrstage does.
Run the mminfo query to verify :
mminfo -q volume=ADVFSVOL -r written
-> sample 5GB.
It does.

IF NSRSTAGE does finish before SAVE does.
Run the mminfo query to verify :
mminfo -q volume=ADVFSVOL -r written
-> sample 15GB.
WRONG. nsrstage fails to update volume's record because record is busy in 
mediadb.


So, if you monitor the device, at this stage, used size is 15GB.
If you launch again a staging, it will stage the only real 5GB data and
decrease by 5GB volume written size, so setting it to 10GB.
But it never return to 0 even if volume does not contain any saveset.
The only way is relabeling the volume.

-> your ADVFILE usage is, for networker, always 10GB.

Looking at .RO volume record ??  media db is always 0, you cannot write to a
read-only flagged volume ;-D

So, knowing the ssid being active when your nsrstage cmd does start is the key
to can adapt pool selection or backup scheduling avoiding it.

Another one being staying in front of the console all night long :-)

Kind regards - Bien cordialement - Vriendelijke groeten,

Thierry FAIDHERBE
Backup/Storage & System Management

LE FOREM
Département des Systèmes d'Information
Direction Infrastructure

Boulevard Tirou, 104  Tel:    +32 (0)71/206730
B-6000 CHARLEROI      Mobile: +32 (477)/995319
                      Fax:    +32 (0)71/206199
BELGIUM               Mail : Thierry.faidherbe<at>forem.be

"The urgent is done, the impossible is being processed ... For miracles Allow 
time".
"The future belongs to those who believe in the beauty of their dreams", 
Eleanor Roosevelt
"Nowadays, people know the price of everything and the value of nothing", Oscar 
Wilde


-----Message d'origine-----
De : Hirter Marcel [mailto:Marcel.Hirter AT ne DOT ch]
Envoyé : mardi 3 septembre 2013 15:14
À : FAIDHERBE Thierry; EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE 
DOT EDU> (NETWORKER AT LISTSERV.TEMPLE DOT EDU)
Objet : RE: Help/Ideas getting SSID writing on ADV_FILE device...

Hi,
For the ssid I don't know yet

But for what is in progress

Nsradmin
Option hidden:on
Option dynamic:on
Show session
Print

Why do you want the ssid
À bientôt
Marcel

-----Message d'origine-----
De : owner-networker AT LISTSERV.TEMPLE DOT EDU [mailto:owner-networker AT 
LISTSERV.TEMPLE DOT EDU] De la part de FAIDHERBE Thierry
Envoyé : mardi, 3. septembre 2013 14:05
À : EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> (NETWORKER 
AT LISTSERV.TEMPLE DOT EDU)
Objet : Help/Ideas getting SSID writing on ADV_FILE device...

Hello,

Question for Champions !!! (Version 7.6.4)

Does anyone know a way/trick to gather active SSID/session being written to an 
Adv_file device before completion ?

Trivial query like mminfo -q "volume=xxx,incomplete"
does off course not provide the info :-)

Any idea or work around ?

Kind regards - Bien cordialement - Vriendelijke groeten,

Thierry FAIDHERBE
Backup/Storage & System Management

LE FOREM
Département des Systèmes d'Information
Direction Infrastructure

Boulevard Tirou, 104  Tel:    +32 (0)71/206730
B-6000 CHARLEROI      Mobile: +32 (477)/995319
                      Fax:    +32 (0)71/206199
BELGIUM               Mail : Thierry.faidherbe<at>forem.be

"The urgent is done, the impossible is being processed ... For miracles Allow 
time".
"The future belongs to those who believe in the beauty of their dreams", 
Eleanor Roosevelt "Nowadays, people know the price of everything and the value 
of nothing", Oscar Wilde