Hallo all
Is it possible to change schema of table in DB2 v.8.2 without
recreating and coping a table into a new schema?
I need it for several purposes, one of them - refactoring of existing

I have a table with lots of stock movements.  ( stockmovements)
Once per year the user need to run a routine that move these records
into a table (history) and delete the movements from the original
table (stockmovements).

We have a UDB 9.1 fp 1 mutlipartition environment.....
We noticed the database directory filesystem on NODE 0 reaches 100
%... and SYSTOOLSTMPSPACE tablespace (managed by automatic storage)
runs out of space...

I have a  test table
//---------------------------
name    varchar(32)
version  varchar(16)

I had a node cataloged with an explict IP-address.
I tried to change to a fully qualified name but:
db2 catalog tcpip node mynode  remote db2server.mycompany.biz server 50001
The catalog command was acccepted, db2 was restarted,

I am tryieng to convert our time consuming  recursive queries too very
efficient queries based
on nested set model.
The only problem is to convert an adjacency list model into a nested set

I would like to hear your oppion about the follow partitioning keys.
With the goal to have an evenly distributed dataset around all
partitions we chose the following:
No

I would like to access to a MS-ACCESS-DB/Windows-Server from zOS/DB2
via COBOL/ODBC-Program.
Can anybody help me ?

I've tried to find out license information for WLM and DB2 9.5 but did not
succeed.
Can someone tell me the policy to use WLM: is it available free in ESE, as a
license ? is is available on WSE and EXP ?

"bad page", especially in table, is a risk for database maintenance.
The particular access
attempt for corrupt blocks may not occur often, and corrupt DB2 blocks
are not recognized during a database backup, corrupt blocks can remain

Environment:
DB2 v8 LUW FP 15 running on Linux.
For some reason that I can´t explain, a simple insert statement on a
table may run very quickly, or may take forever (20-30mins) to finish.

All,
  Can someone provide me the link to download 'DB2  admin client for
Linux Red Hat Linux AS/EX 3.0/x86'?
Is this a free download?    Our UDB's on the backend are all

IHello,
I've a table like this (location withprobably more than i ip address) :
NAME    IP_ADDRESS
host1    1.1.x

I was trying to load a comma-separated text file to a DB2 table.  I
believe I have the syntax rigt for the LOAD command.
My first question is, how do you actually run it?  It is not a SQL
command; so it doesn't run from the command center/SQL window.  It

I would like to extract the first 6 digits of a numeric value (e.g.
the string '123456' out of the numeric 1234567890123456789).  I tried
a combination of CAST and SUBSTR, but it seems I am not doing the
conversion properly. Please advice: