Product: Aqua Data Studio
Version: 18.0.0-devi-243
Build #: 51267
Build Date: 2016-Sep-25 06:24:28 PM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_101-b13
Memory: Max=704,643,072; Total=425,197,568; Free=229,864,880; CPUs=8
Connect Database DB2 LUW 9.7/ 10.1/10.5
Steps:
Step 1: Run the below script in QA
CREATE LARGE TABLESPACE "tsp1"
MANAGED BY DATABASE
USING( FILE 'C:\IBM\DB2Data\aa' 5120K )
BUFFERPOOL IBMDEFAULTBP
Result: Tablespace tsp1 is created.
Step 2: Right click on 'tsp1' in Tablespace tree node ->Alter Tablespace
Result: Alter tablespace UI is opened for 'tsp1'.
Step 3: Click on 'Preview SQL'
Result: Alter tablespace query 'ALTER TABLESPACE tsp1 GO' is already generated.
Expected Result: Field 'Preview SQL' of 'Alter Tablespace' UI must be initially blank.
Observation:
|
|
|
|
|
|
|
|
|
|
Database |
|
|
DB2 LUW 9.7 |
DB2 LUW 10.1 |
DB2 LUW 10.5 |
|
|
Windows |
Ubuntu |
Windows |
Ubuntu |
Windows |
Ubuntu |
|
ADS 18-devi-243 |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v17 |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v16 |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v15 |
Y |
Y |
Y |
Y |
Y |
Y |
|
ADS v14 |
Y |
Y |
Y |
Y |
N/A |
N/A |
|
|
|
|
|
|
|
|
|
Y - Yes, 'alter tablespace' script is already generated in Preview SQL. |
|
N/A- When we click on Alter Tablespace 'Tablespace is not found' is displayed. |
1.If changes are made in UI then another 'Alter Tablespace' query is generated in 'Preview SQL'.
Please refer attachment-'After changes.png'
2.This Issue occurs only for 'Large' type tablespace and not for 'Regular' ,'System Temporary','User Temporary' Type tablespaces.
3.This issue is specific for DB2 LUW database.
Please refer attachment-'Alter Tablespace.png'
