How to move/copy Data without Intermediate Data(DEL/IXF) Files.
1.Load With Cursor alias Remote Load
2.DB2MOVE with COPY Action

Views: 207


You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Comment by Rajesh Pandhare on August 15, 2013 at 5:16am

Thank you Harish for replying,

I am extremely sorry for posting comments under this video , I was watching video "DB2 Tips and Tricks 5"  which is for MON_GET_TABLE, But I think I misplaced comment under this video.

Thank you very much for clarifying my doubt, All video are very helpful and explanatory. 

Comment by Harishkumar Baburao Pathangay on August 15, 2013 at 1:50am

Hi Rajesh,

The video talks about only data movement and nothing about monitoring.

Any case, since you have raised it , i will answer with assumption you are talking about MON_* Funtions for monitoring. You have to get the before and after values and do the math for delta values.


Harish Pathangay 

Comment by Rajesh Pandhare on August 14, 2013 at 10:49am

Hi Harish,

With Snapshot command we can reset snapshot monitors and can collect snapshots for say only 15 minutes time interval.

So Do we have any such mechanism with Table Functions OR we need to write before and after scripts which will insert data in tables and then calculate delta?

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service