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
 

 

Reasons for AERO* status

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

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Fri Jun 04, 2010 5:13 pm    Post subject: Reasons for AERO* status
Reply with quote

Hi,

Could you please let me know the possible reasons why a tablespace will go into AREO* (Advisory Reorg) status.

I have searched in our forum, i have got only one related to AREO* but that says about the way to resolve it.



Thanks & Regards,
Mallik
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Jun 04, 2010 5:23 pm    Post subject:
Reply with quote

20 seconds on google - from the IBM web site

Quote:
The REORG-pending (AREO*) advisory status indicates that a table space, index, or partition needs to be reorganized for optimal performance.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Jun 04, 2010 5:25 pm    Post subject:
Reply with quote

If some online schema changes (ALTER TABLE) are made , it will become AREO

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.intro/db2z_guidelinesfordatareorganization.htm
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Fri Jun 04, 2010 5:34 pm    Post subject:
Reply with quote

Thanks for the reply,

We have got this status for one of our table.Since it is an advisory reorg we ran REPAIR utility with NOAREORPENDSTAR option. This removed the status.

But the application team(team to which this table belongs to) claiming that due to this utility they lost some records.

I just want to check is there any possiblity that tablespace will put in to AREO* status when some mass delete happens or REPAIR really deletes the records from the database?
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Fri Jun 04, 2010 5:42 pm    Post subject:
Reply with quote

In IBM site it is mentioned that Tablespace will put into AREO* when table got altered.
But this table was getting accessed by application till today and there were no ALTER happend on the table recently.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Jun 04, 2010 10:11 pm    Post subject:
Reply with quote

Mallik4u,

Since you didn't run REORG till now, can you check the tablespace versions in the catalog
SELECT DBNAME, NAME, OLDEST_VERSION ,CURRENT_VERSION
FROM SYSIBM.SYSTABLESPACE

Thanks,
Sushanth
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Mon Jun 07, 2010 11:02 am    Post subject:
Reply with quote

hi Susanth,

Thanks for the reply!!!

I have ran the query. I got result as Current_Version is 1 and old_version is 0.

Is there any way that i can retrive the old version?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Jun 07, 2010 6:24 pm    Post subject:
Reply with quote

Mallik4u,

Quote:
Is there any way that i can retrive the old version?

Can you please tell me why do you want to retreive the old version ?

Sushanth
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: Mon Jun 07, 2010 10:07 pm    Post subject:
Reply with quote

Hi Sushanth,

Seems like something was "altered" after all. . . icon_wink.gif

Now the original is needed. . .

Just a guess.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Jun 07, 2010 10:35 pm    Post subject:
Reply with quote

Hi D.sch,

Tablespace versions are basically used for data availability purposes and not for recovery.

So, the options left for Mallik is to,
ALTER the table to backout the changes done earlier & do a REORG.
or
DROP & re-create with the old ddl.

And i don't think tha'ts gonna happen, since malik said,
Quote:
But this table was getting accessed by application till today and there were no ALTER happend on the table recently.


So, i think for a long time, this has been left un-noticed, so it would be better they take DB2's advice and do a REORG. And get rid of Advisory REORG pending status and tablespace versions.

Thanks,
Sushanth
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 Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
This topic is locked: you cannot edit posts or make replies. session stuck in TPX with status ACL amitc23 CA Products 1 Tue Dec 13, 2016 12:53 pm
No new posts How to resolve IMS DB status code FM Priyanka Boga IMS DB/DC 3 Fri Jun 10, 2016 1:54 pm
No new posts JCL to fetch schedule status from act... parasmalik20 CA Products 1 Thu Jun 02, 2016 7:11 pm
No new posts How to read the db2 table space statu... cmsmoon DB2 3 Fri Apr 17, 2015 2:29 am


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