UDB session and db2flsn

[Raquel]

Hello!!

Had some UDB related questions:

1. What is a 'session' in UDB? For example, the manual says "If a backup
image was created using multiple sessions, db2ckbkp can examine all of
the files at the same time. Users are responsible for ensuring that the
session with sequence number 001 is the first file specified."

2. How does db2flsn work? Where is the 'mapping' between the logs and the
LSN ranges stored? Is it in SQLOGCTL.LFG file? Also, the manual has
this to say about db2flsn: "The tool uses the logfilsiz database
configuration parameter."
Why is db2flsn dependent on 'logfilsz' parameter?

TIA
Raquel.

[Kelly D. Rodger]

Raquel, the BACKUP utility allows you to specify multiple targets to be
written to in parallel. Each of those target paths or devices will
create at least one backup image, each with it's own sequence number.
The individual files are referred to as either sequences or sessions.

If the backup target is a storage manager such as TSM, the BACKUP syntax is:

BACKUP DB <alias>... USE TSM [OPEN <n> SESSIONS]

Hence the term "sessions" - it refers to a communications channel with
some storage target.

Hope that helps.
kdr
Raquel wrote:

1. What is a 'session' in UDB? For example, the manual says "If a backup
image was created using multiple sessions, db2ckbkp can examine all of
the files at the same time. Users are responsible for ensuring that the
session with sequence number 001 is the first file specified."

--
================================================== ===================
Kelly D. Rodger IBM Canada
DB2 UDB Development Backup & Restore
================================================== ===================

[Fan Ruo Xin]

Raquel wrote:

Hello!!

2. How does db2flsn work? Where is the 'mapping' between the logs and the
LSN ranges stored? Is it in SQLOGCTL.LFG file? Also, the manual has
this to say about db2flsn: "The tool uses the logfilsiz database
configuration parameter."
Why is db2flsn dependent on 'logfilsz' parameter?
Check the manual for the definition of LSN. Then I think you can understand
all the questions you asked here.


TIA
Raquel.