Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Incremental Image Copy Jobs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Thu Mar 25, 2010 6:16 pm    Post subject: DB2 Incremental Image Copy Jobs
Reply with quote

Hello.

Please let me know- How the DB2 incremental image copy jobs are working to take (or down load)only the changed pages since from last image copy recorded in DB2 SYSCOPY.

We use utility program DSNUTILB with SYSIN
COPY TABLESPACE xxx FULL NO SHRLEVEL CHANGE DSNUM nn

Thanks in advance
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 25, 2010 9:16 pm    Post subject:
Reply with quote

Hello,

Suggest you add some clarification as to what you are looking for. . .

An incremental backup is just that - information changed since the previous backup. . .

Probably, there is something i am missing.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Mar 26, 2010 11:52 am    Post subject:
Reply with quote

Hello Raghav,

Generally for incremental Image copy does not require a complete scan for Tablespace except:
1. tablespace defined as TRACKMOD NO
2. First image copy after Altering TS to TRACKMOD YES

Spacemap for each TS for each page regardless whether its changed for last image copy.Incremental image copies of a table space that is defined
with TRACKMOD NO still saves space, although the performance advantage is
smaller.

Hope it will helpful
Back to top
View user's profile Send private message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Fri Mar 26, 2010 3:25 pm    Post subject:
Reply with quote

Hello.

I'm looking forward to know -

1) How the utility program works to recognize the changed pages since from previous backup (how it compares the current data in the tablespace with previous backup data)

2) Is the utility program refers any of the DB2 catalog tables to identify the changed pages? If yes, please explain
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Mar 26, 2010 3:48 pm    Post subject:
Reply with quote

Hello Raghav,

That was I explained in my prev post. It refer the spacemap to identify
whether the pagE was changed from the last image copy if it is defined as TRACKMOD YES.
Back to top
View user's profile Send private message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Fri Mar 26, 2010 5:01 pm    Post subject: DB2 Incremental Image Copy
Reply with quote

Hello Ekta,

Thanks for your information, as you mentioned about TRACKMOD (YES/NO), I found some more information on this.

Thanks
Raghav08
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 5 Thu Apr 27, 2017 1:15 am
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts Mail via SMTP with an image? Mike 1304 JCL & VSAM 4 Thu Jan 26, 2017 2:01 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us