473,230 Members | 1,884 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,230 software developers and data experts.

pagesize increase or longvarchar

I have a table whose rowsize is nearing 4005 bytes and I want to
increase the length of one column. I know I have two ways to do this.
I can either increase the tablespace pagesize from 4K to 8K, or change
the column from being a varchar to longvarchar. Which is
better(performance wise)?

Also is it true that you cannot change the page sizes of tablespaces
on-the-fly -- you will have to export your data, drop all objects that
exist in the
tablespace, create new tablespaces with a larger page size, recreate
all
objects in the new tablespace, and the import your data.

Thanks in advance.
Nov 12 '05 #1
3 6475
If you're at V8.2, investigate whether or not the column change can be
done by looking at your docs. - I don't have them.
If you access the long varchar regularly thru your queries, you will pay
the following performance price.
2 I/O's per row. One to get the page, one to get the long varchar. That
one goes to agent private memory, not the buffer pool.

See below #######.
HTH, Pierre.

Naren Mehta wrote:
I have a table whose rowsize is nearing 4005 bytes and I want to
increase the length of one column. I know I have two ways to do this.
I can either increase the tablespace pagesize from 4K to 8K, or change
the column from being a varchar to longvarchar. Which is
better(performance wise)? ####### Yes this is true. Page size are fixed and cannot be altered. Also is it true that you cannot change the page sizes of tablespaces
on-the-fly -- you will have to export your data, drop all objects that
exist in the
tablespace, create new tablespaces with a larger page size, recreate
all
objects in the new tablespace, and the import your data.

Thanks in advance.


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #2
Thanks a lot.

Pierre Saint-Jacques <se*****@attglobal.net> wrote in message news:<41**************@attglobal.net>...
If you're at V8.2, investigate whether or not the column change can be
done by looking at your docs. - I don't have them.
If you access the long varchar regularly thru your queries, you will pay
the following performance price.
2 I/O's per row. One to get the page, one to get the long varchar. That
one goes to agent private memory, not the buffer pool.

See below #######.
HTH, Pierre.

Naren Mehta wrote:
I have a table whose rowsize is nearing 4005 bytes and I want to
increase the length of one column. I know I have two ways to do this.
I can either increase the tablespace pagesize from 4K to 8K, or change
the column from being a varchar to longvarchar. Which is
better(performance wise)?

####### Yes this is true. Page size are fixed and cannot be altered.
Also is it true that you cannot change the page sizes of tablespaces
on-the-fly -- you will have to export your data, drop all objects that
exist in the
tablespace, create new tablespaces with a larger page size, recreate
all
objects in the new tablespace, and the import your data.

Thanks in advance.

Nov 12 '05 #3
Pierre - one thing to remember is that LONG VARCHAR will be deprecated in upcoming
releases so it is not wise to continue using them unless absolutely necessary ... consider
the LOB type column of CLOB in that case if absolutely necessary.

--

Bob
Engagement Specialist - DB2 Information Management Software - IBM Software Group
IBM Toronto Lab
[My comments are solely my own and are not meant to represent an official IBM position -
ask my cat!]

"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:41**************@attglobal.net...
If you're at V8.2, investigate whether or not the column change can be
done by looking at your docs. - I don't have them.
If you access the long varchar regularly thru your queries, you will pay
the following performance price.
2 I/O's per row. One to get the page, one to get the long varchar. That
one goes to agent private memory, not the buffer pool.

See below #######.
HTH, Pierre.

Naren Mehta wrote:
I have a table whose rowsize is nearing 4005 bytes and I want to
increase the length of one column. I know I have two ways to do this.
I can either increase the tablespace pagesize from 4K to 8K, or change
the column from being a varchar to longvarchar. Which is
better(performance wise)?

####### Yes this is true. Page size are fixed and cannot be altered.
Also is it true that you cannot change the page sizes of tablespaces
on-the-fly -- you will have to export your data, drop all objects that
exist in the
tablespace, create new tablespaces with a larger page size, recreate
all
objects in the new tablespace, and the import your data.

Thanks in advance.


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Niels | last post by:
Hello Can anyone help me with the following: I want to show the page of an pdf (the pdf has only 1 page) on a form, and the size of the pdf in a label. Thanks
1
by: David | last post by:
Hi All I am trying to read a LongVarChar field from SQL Server using the SqlDataReader and I am having trouble. Can anyone provide an example or assistance. I found the article...
1
by: Stephen Hatfield | last post by:
I am working on part of an application most of which is being developed outside of my group. I may actually have two problems here. I have a GridView for which the columns are generated dynamically...
4
by: Adam Sandler | last post by:
Hello, Using VWD 2005 here and I want to set the GridView PageSize at runtime. This URL has an example of what I exactly want to do......
1
by: pike | last post by:
DB2 v8.1 FP 11 on AIX 5.2. A REORG of a table created in a 4KB-PAGESIZE tablespaces with associated LONG data stored in a 16KB tablespace is failing with the following error: SQL2217N The...
0
by: active | last post by:
I run the code below and in the diialog box I click Properties and set a custom page size. But when I check PageSize in mPD the custom size is not there. Any help for this? Thanks
0
by: rn5a | last post by:
In a shopping cart app, a user purchases 5 items on 31st March 2007. This is his 1st order. He places a 2nd order on 13th April in which he buys 8 items. Next he places his 3rd order on 16th April...
1
by: nityaprashant | last post by:
Hello.. i have datalist & want to use paging in 3- tier architecture. adt.fill(ds, currenetpageindex, pagesize,"Customers") i want to use another method in 3-tier archi. dataset is filled in...
2
by: icanhelp33 | last post by:
I would like to assign dynamic pagesize to a gridview called gridCustomer. The customer data is a List with a column called groupId . When a new groupid is encountered I would like to display data...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.