Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2008
    Location
    Delhi, India
    Posts
    15

    Unanswered: DB2 v8 Alter Data Type

    Hi,

    I have a table in DB2 v8 in which a column is of INTEGER Type. It have some data as well, I want to convert it to varchar(20). I am using AQT tool, when I trying to alter it Combo box is coming as disabled.

    When I try from Command Window, get following error:

    Make the attributes specified compatible with the existing column,
    remove the attribute specification, or specify a different column name.


    I heard that we can't alter structure in DB2 v8, is it so?

    Is there any command using which we can find the DB2 version?

    Thanks,
    Last edited by nitingautam; 06-09-10 at 01:20.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    That feature is not available in DB2 V8 LUW. You can find the DB2 release with the "db2level" command issued from a command line session. Believe it or not, IBM actually publishes DB2 manuals and they are available in PDF format to be downloaded for free. You will want the SQL Reference Vol 2 manual for release 8.2 (I am assuming you have 8.2, which is the same as 8.1 FP 7 or later).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2008
    Location
    Delhi, India
    Posts
    15
    Quote Originally Posted by Marcus_A View Post
    That feature is not available in DB2 V8 LUW. You can find the DB2 release with the "db2level" command issued from a command line session. Believe it or not, IBM actually publishes DB2 manuals and they are available in PDF format to be downloaded for free. You will want the SQL Reference Vol 2 manual for release 8.2 (I am assuming you have 8.2, which is the same as 8.1 FP 7 or later).
    When I connected to database using command line I got following output:

    Database server = DB2/SUN64 9.5.5
    SQL authorization ID = XXXXXX
    Local database alias = XXXXXX

    This means we have 8 version installed...if it is so, how to alter table in this version?

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    yes DB2/SUN64 9.5.5 means v8 is installed
    I mean.. it clearly indicates V9 ?????
    db2level has to be executed on server to see server level
    it would be a good idea to read some about db2
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Nov 2008
    Location
    Delhi, India
    Posts
    15
    It only says
    Database server = DB2/SUN64 9.5.5 .

    Means there is no method to change the datatype

  6. #6
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    (Deleted. Because of my misunderstanding)
    Last edited by tonkuma; 06-09-10 at 15:52.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •