473,320 Members | 1,794 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Rename a tablespace file?

Hi,
I have started using Db2 V9 on AIX 5L and in the process of getting to grips with it I wondered if it has the ability to rename tablespace files. I could not find anything in the docs to indicate this ability. I am thinking of a situation where I want to move tablespaces around disk logical volumes.

Regards

Pete
Jul 9 '07 #1
2 2634
Hi,
I have started using Db2 V9 on AIX 5L and in the process of getting to grips with it I wondered if it has the ability to rename tablespace files. I could not find anything in the docs to indicate this ability. I am thinking of a situation where I want to move tablespaces around disk logical volumes.

Regards

Pete
Try this:
RENAME TABLESPACE statement
The RENAME TABLESPACE statement renames an existing table space.

Invocation
This statement can be embedded in an application program or issued
through the use of dynamic SQL statements. It is an executable statement
that can be dynamically prepared only if DYNAMICRULES run behavior is in
effect for the package (SQLSTATE 42509).

Authorization
The privileges held by the authorization ID of the statement must
include either SYSCTRL or SYSADM authority.

Syntax
>>-RENAME--TABLESPACE--source-tablespace-name------------------->

>--TO--target-tablespace-name----------------------------------><

good luck

___________
Janet Kellman, software reviews
Jul 9 '07 #2
Thanks for the pointer.

Pete
Jul 10 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: robert | last post by:
just got out of a "class" on EXPLAIN, from a 390/v6 maven. was told that ACCESSTYPE = 'R' in the plan_table meant a TableSpace scan. hmmmm. next step up (or down, depending on your outlook)...
6
by: Raj | last post by:
How can we do an online restore of a tablespace using the incremental backup's? we are on a partitioned database... Also, how could we use backup copy made by the load (using the copy to option...
4
by: Joachim Klassen | last post by:
DB2 V8.2 FP10 on Windows I tested the following HADR scenario: - a new tablespace on a new filesytem is created on the primary System - the replay on standby fails because of lacking permissions...
1
by: deshaipet | last post by:
Hi friends - I created a automatic storage tablespace with a pagesize of 16 K and initial size of 64 MB. create large tablespace test_tbsp1 pagesize 16k managed by automatic storage autoresize...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.