sysproc.snapshot_tbreorg: What does rergo_status value '4' means ?

This is a discussion on sysproc.snapshot_tbreorg: What does rergo_status value '4' means ? within the ibm-db2 forums in Other Databases category; Hi , sysproc.snapshot_tbreorg result shows me REORG_STATUS as '4' Does anyone know what does it means ? Regards Myoungsoo...

Go Back   Database Forum > Other Databases > ibm-db2

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-25-2008, 01:19 AM
Default sysproc.snapshot_tbreorg: What does rergo_status value '4' means ?

Hi ,

sysproc.snapshot_tbreorg result shows me REORG_STATUS as '4'

Does anyone know what does it means ?


Regards

Myoungsoo
Reply With Quote
  #2  
Old 08-25-2008, 09:16 AM
Default Re: sysproc.snapshot_tbreorg: What does rergo_status value '4' means?

> sysproc.snapshot_tbreorg *result shows me REORG_STATUS as '4'
> Does anyone know what does *it means ?


From "sqlmon.h"

/
************************************************** ****************************/
/* reorg table
defines */
/
************************************************** ****************************/

#define SQLM_REORG_STARTED 1
#define SQLM_REORG_PAUSED 2
#define SQLM_REORG_STOPPED 3
#define SQLM_REORG_COMPLETED 4
#define SQLM_REORG_TRUNCATE 5

Regards,
Udo

--
Speedgain The DB2 Monitor
http://www.itgain.de/en/produkte/speedgain.html
Reply With Quote
  #3  
Old 08-25-2008, 06:02 PM
Default Re: sysproc.snapshot_tbreorg: What does rergo_status value '4' means?



Thanks Udo ,
That's exactly what I'm looking for .
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 12:15 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.