[Fwd: [Fwd: Re: Altering fields]]

Ruediger Kurtz

[Fwd: [Fwd: Re: Altering fields]]
Phil,

as you mentioned DBArtisan just one question, how do you alter a
tablespace using DBArtisan ?

TIA Ruediger




[login to unmask email] wrote:
>
> --
> >"""""<
> !_ _!
> (o) (o)
> oOOO--(_)--OOOo-----------------------------------------------------*
> * *
> * Thomas Roedel *
> * *
> * HUK-Coburg Phone: 09561/96-3915 *
> * Versicherungen-Bausparen Fax : 09561/96-3678 *
> * Abt. Informatik (Datenbanken) *
> * Bahnhofsplatz Mail: [login to unmask email] *
> * 96450 Coburg *
> *-------------------------------------------------------------------*
>
> ---------------------------------------------------------------
>
> Subject: [Fwd: Re: Altering fields]
> Date: Thu, 07 Oct 1999 16:09:02 +0100
> From: [login to unmask email]
> Organization: HUK-Coburg
> To: [login to unmask email]
>
> --
>
> ---------------------------------------------------------------
>
> Subject: RE: Altering fields
> Date: Thu, 7 Oct 1999 08:56:09 -0400
> From: [login to unmask email] (Philip Gunning)
> To: "'[login to unmask email]'" <[login to unmask email]>
>
> Ruediger, We have been using DBArtisan with DB2 UDB on NT v5.0.5.2.,v6.1.
> We like it. Phil
>
> Phil Gunning
> DB2 DBA
> IBM Certified Solutions Expert -- DB2 UDB
> IBM Certified Solutions Expert -- CICS TS
>
> -----Original Message-----
> From: [login to unmask email] [SMTP:[login to unmask email]
> Sent: Thursday, October 07, 1999 3:28 AM
> To: [login to unmask email]
> Subject: Re: Altering fields
>
> Craig,
>
> >I presume we're talking about UDB, so what are those vendors you're
> mentioning, apart from embarcadero and BMC; we're currently looking
> desperately for such a tool since we're about to launch our first
> application and are awaiting the first changes to structures.
>
> TIA Ruediger Kurtz
>
> Mullins, Craig wrote:
> >
> > K:
> >
> > Yes, it is true that you can not simply ALTER the data type of columns in
> > DB2 tables once they have been created. In order to change the data type
> you
> > must DROP and re-CREATE the object. You must be sure to save off all of
> the
> > data, and related objects (indexes, views, security, etc.) before
> dropping
> > it so that you can re-apply it all once the object has been re-created.
> > There are several vendor tools on the market that automate this
> > functionality making it simpler to perform, if you are interested.
> >
> > Cheers,
> > Craig S. Mullins
> > Director, DB2 Technology Planning
> > BMC Software
> > http://www.bmc.com/products/env_page.html?id=5009
> >
> > -----Original Message-----
> > From: Leonardo Kenji Shikida [mailto:[login to unmask email]
> > Sent: Wednesday, October 06, 1999 10:43 AM
> > To: [login to unmask email]
> > Subject: Altering fields
> >
> > Is that true that DB2 doesn't allow to modify fields type after a table
> is
> > created ?
> > I said, how can I chance for example a "name" field from character(10) to
> > varchar(30) for example ? Control Center doesn't allow me to do this,
> > neither
> > alter database SQL command.
> >
> > thanks in advance
> >
> > K
>
> --

--

Deepak Kumar (CTS) Thakral

Re: Altering fields
(in response to Ruediger Kurtz)
Richard,
On receiving K's and Craig's mail, we tried using this ALTER command to
increase the lenght of the varchar field . The syntax is as follows :
ALTER TABLE table-name
ALTER COLUMN column-alteration
SET DATA TYPE VARCHAR (integer)

When we tried using this on DB2 version 5 for os/390 , we got a -199 SQL
REturn code.
Do we need to do some retrofitting on our DB2 version to enable this. If so
how do we go about doing it.
Thanks in Advance
Deepak.

-----Original Message-----
From: Richard A Yevich [mailto:[login to unmask email]
Sent: Friday, October 08, 1999 3:32 AM
To: [login to unmask email]
Subject: Re: Altering fields


There IS ONE ALTER that is being added to DB2 and retrofitted to V5 and that
is to increase the length of a VARCHAR.

Richard Yevich
+=====+======+
Information Technology Consulting, Data Modeling, Advanced Education
RYC® Inc. USA: 1-800-664-2421 Int'l: 1-305-361-8585 Fax: 1-512-476-3930
Web: < http://www.ryci.com > Email: [login to unmask email] Offices: USA and Europe
DB2® Family and Oracle® Specialists - Parallel Technologies
VLDB and Data Sharing Technologies (specialties SAP®, Peoplesoft®)
Authors of "DB2 Answers" by Osborne-McGraw Hill, May, 1999


> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
> Leonardo Kenji Shikida
> Sent: Wednesday, October 06, 1999 11:43 AM
> To: [login to unmask email]
> Subject: Altering fields
>
>
> Is that true that DB2 doesn't allow to modify fields type after a table is
> created ?
> I said, how can I chance for example a "name" field from character(10) to
> varchar(30) for example ? Control Center doesn't allow me to do
> this, neither
> alter database SQL command.
>
> thanks in advance
>
> K
>

Venkat (PCA) Pillay

Re: Altering fields
(in response to Deepak Kumar (CTS) Thakral)
You have to have APAR PQ16674 - "EXTEND VARCHAR LENGTH clause of ALTER
TABLE"


> -----Original Message-----
> From: Thakral, Deepak Kumar (CTS) [SMTP:[login to unmask email]
> Sent: Friday, October 08, 1999 9:25 AM
> To: [login to unmask email]
> Subject: Re: Altering fields
>
> Richard,
> On receiving K's and Craig's mail, we tried using this ALTER command to
> increase the lenght of the varchar field . The syntax is as follows :
>
> ALTER TABLE table-name
> ALTER COLUMN column-alteration
> SET DATA TYPE VARCHAR (integer)
>
> When we tried using this on DB2 version 5 for os/390 , we got a -199 SQL
> REturn code.
> Do we need to do some retrofitting on our DB2 version to enable this. If
> so how do we go about doing it.
> Thanks in Advance
> Deepak.
>
> -----Original Message-----
> From: Richard A Yevich [ <mailto:[login to unmask email]>]
> Sent: Friday, October 08, 1999 3:32 AM
> To: [login to unmask email]
> Subject: Re: Altering fields
>
>
> There IS ONE ALTER that is being added to DB2 and retrofitted to V5 and
> that
> is to increase the length of a VARCHAR.
>
> Richard Yevich
> +=====+======+
> Information Technology Consulting, Data Modeling, Advanced Education
> RYC® Inc. USA: 1-800-664-2421 Int'l: 1-305-361-8585 Fax: 1-512-476-3930
> Web: < < http://www.ryci.com> > Email: [login to unmask email] Offices: USA and
> Europe
> DB2® Family and Oracle® Specialists - Parallel Technologies
> VLDB and Data Sharing Technologies (specialties SAP®, Peoplesoft®)
> Authors of "DB2 Answers" by Osborne-McGraw Hill, May, 1999
>
>
> > -----Original Message-----
> > From: DB2 Data Base Discussion List [ <mailto:[login to unmask email]>]On Behalf
> Of
> > Leonardo Kenji Shikida
> > Sent: Wednesday, October 06, 1999 11:43 AM
> > To: [login to unmask email]
> > Subject: Altering fields
> >
> >
> > Is that true that DB2 doesn't allow to modify fields type after a table
> is
> > created ?
> > I said, how can I chance for example a "name" field from character(10)
> to
> > varchar(30) for example ? Control Center doesn't allow me to do
> > this, neither
> > alter database SQL command.
> >
> > thanks in advance
> >
> > K
> >
>

Craig Mullins

Re: Altering fields
(in response to Venkat (PCA) Pillay)
Mr. Kurtz:

I was talking about DB2 UDB for OS/390 in my response regarding altering
columns. Although I believe it is applicable to DB2 UDB on other platforms
as well. You have to be careful with terminology these days because DB2 is
now UDB on OS/390 as well as on NT, AIX, OS/2, etc. For alteration tools
from BMC check out Alter and Change Manager (for OS/390) and Patrol DB-Alter
and patrol DB-Change Manager (for distributed platforms).

Cheers,
Craig S. Mullins
Director, DB2 Technology Planning
BMC Software
[login to unmask email]


>Date: Thu, 7 Oct 1999 08:27:31 +0100
>From: [login to unmask email]
>Subject: Re: Altering fields
>
>Craig,
>
>I presume we're talking about UDB, so what are those vendors you're
mentioning, apart from embarcadero and BMC; we're >currently looking
desperately for such a tool since we're about to launch our first
application and are awaiting the >first changes to structures.
>
>TIA Ruediger Kurtz

Phil Grainger

Re: Altering fields
(in response to Craig Mullins)
Or of course there's also RC/Migrator, RC/Compare and RC/Update for OS390 as
well as Enterprise DBA and Desktop DBA for non-mainframe platforms - all
from Computer Associates.

I'm surprised Craig has forgotten to mention those!!

Phil Grainger
Director DB2 Operations, Europe
Computer Associates International

> -----Original Message-----
> From: Mullins, Craig [SMTP:[login to unmask email]
> Sent: Friday, October 08, 1999 4:49 PM
> To: [login to unmask email]
> Subject: Re: Altering fields
>
> Mr. Kurtz:
>
> I was talking about DB2 UDB for OS/390 in my response regarding altering
> columns. Although I believe it is applicable to DB2 UDB on other
> platforms
> as well. You have to be careful with terminology these days because DB2 is
> now UDB on OS/390 as well as on NT, AIX, OS/2, etc. For alteration tools
> from BMC check out Alter and Change Manager (for OS/390) and Patrol
> DB-Alter
> and patrol DB-Change Manager (for distributed platforms).
>
> Cheers,
> Craig S. Mullins
> Director, DB2 Technology Planning
> BMC Software
> [login to unmask email]
>
>
> >Date: Thu, 7 Oct 1999 08:27:31 +0100
> >From: [login to unmask email]
> >Subject: Re: Altering fields
> >
> >Craig,
> >
> >I presume we're talking about UDB, so what are those vendors you're
> mentioning, apart from embarcadero and BMC; we're >currently looking
> desperately for such a tool since we're about to launch our first
> application and are awaiting the >first changes to structures.
> >
> >TIA Ruediger Kurtz