Migrating UDB V8.2 to V9.5 on Aix

LOL.... good one Mark....

Mark A wrote:
> wrote in message
>
> > Hi,
> >
> > I am migrating the above and have regular tablespaces, what's the best
> > way to convert these tablespaces to large. I know you can achieve this
> > via an alter tablespace, is their any other way?
>
> If you concentrate very hard while looking at the tablespace name, and think
> "large, large, large, large, ...", then if you are really lucky then it will
> automatically change from a regular to large tablespace without you issuing
> any DB2 commands.
 >> Stay informed about: Migrating UDB V8.2 to V9.5 on Aix 

On Mar 22, 3:31 am, Arun Srinivasan wrote:
> LOL.... good one Mark....
>
>
>
> Mark A wrote:
> > wrote in message
> >
> > > Hi,
>
> > > I am migrating the above and have regular tablespaces, what's the best
> > > way to convert these tablespaces to large. I know you can achieve this
> > > via an alter tablespace, is their any other way?
>
> > If you concentrate very hard while looking at the tablespace name, and think
> > "large, large, large, large, ...", then if you are really lucky then it will
> > automatically change from a regular to large tablespace without you issuing
> > any DB2 commands.- Hide quoted text -
>
> - Show quoted text -

:)
 >> Stay informed about: Migrating UDB V8.2 to V9.5 on Aix 

On 21 Mar, 04:21, "Mark A" wrote:
> wrote in message
>
>
>
> > Hi,
>
> > I am migrating the above and have regular tablespaces, what's the best
> > way to convert these tablespaces to large. I know you can achieve this
> > via an alter tablespace, is their any other way?
>
> If you concentrate very hard while looking at the tablespace name, and think
> "large, large, large, large, ...", then if you are really lucky then it will
> automatically change from a regular to large tablespace without you issuing
> any DB2 commands.

Hi,

It is very disappointing you have replied with a childish comment.
This is a serious discussion group.

Thanks.
 >> Stay informed about: Migrating UDB V8.2 to V9.5 on Aix 

On Mar 25, 11:38 am, Larry wrote:
> wrote:
> > On 21 Mar, 04:21, "Mark A" wrote:
> >> wrote in message
>
> >>
>
> >>> Hi,
> >>> I am migrating the above and have regular tablespaces, what's the best
> >>> way to convert these tablespaces to large. I know you can achieve this
> >>> via an alter tablespace, is their any other way?
> >> If you concentrate very hard while looking at the tablespace name, and think
> >> "large, large, large, large, ...", then if you are really lucky then it will
> >> automatically change from a regular to large tablespace without you issuing
> >> any DB2 commands.
>
> > Hi,
>
> > It is very disappointing you have replied with a childish comment.
> > This is a serious discussion group.
>
> > Thanks.
>
> Maybe you can start by explaining what you mean by coverting a
> tablespace to "large".
>
> Larry E.

If you want to convert an existing tablespace to use Large Record
Identifiers (RIDs), you can use the alter tablespace ..... convert
large.

Due to the increase in the RID sizes to support a LARGE table space,
the growth rate for log files and size of log records will increase
An increase in memory usage will result as each additional RID now
requires 8 bytes of memory for single-partition environment and 16
bytes of memory for partitioned database environment

http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.u...rn..doc

You need to consider indexes when converting to large RIDs (IE reorg
or rebuilt).
 >> Stay informed about: Migrating UDB V8.2 to V9.5 on Aix 

wrote:
> On 21 Mar, 04:21, "Mark A" wrote:
>> wrote in message
>>
>>
>>
>>> Hi,
>>> I am migrating the above and have regular tablespaces, what's the best
>>> way to convert these tablespaces to large. I know you can achieve this
>>> via an alter tablespace, is their any other way?
>> If you concentrate very hard while looking at the tablespace name, and think
>> "large, large, large, large, ...", then if you are really lucky then it will
>> automatically change from a regular to large tablespace without you issuing
>> any DB2 commands.
>
> Hi,
>
> It is very disappointing you have replied with a childish comment.
> This is a serious discussion group.
>
> Thanks.
>
Maybe you can start by explaining what you mean by coverting a
tablespace to "large".

Larry E.
 >> Stay informed about: Migrating UDB V8.2 to V9.5 on Aix 

On Mar 25, 9:23 am, wrote:
> On 21 Mar, 04:21, "Mark A" wrote:
>
> > wrote in message
>
> >
>
> > > Hi,
>
> > > I am migrating the above and have regular tablespaces, what's the best
> > > way to convert these tablespaces to large. I know you can achieve this
> > > via an alter tablespace, is their any other way?
>
> > If you concentrate very hard while looking at the tablespace name, and think
> > "large, large, large, large, ...", then if you are really lucky then it will
> > automatically change from a regular to large tablespace without you issuing
> > any DB2 commands.
>
> Hi,
>
> It is very disappointing you have replied with a childish comment.
> This is a serious discussion group.
>
> Thanks.

I don't think the reply as childish.
DB2 makes a command specially to alter tablespaces to large and you
ask "Can I do this wiby another without using the command?"
How do you expect to do this without the command does not seem to be a
vey serious question !!!!!
Regards, Pierre.
PS: May be if you queried the documentation for yourself ypou would
get a quick answer to your question: NO!
 >> Stay informed about: Migrating UDB V8.2 to V9.5 on Aix