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

temporary tablespace without sufficient page for replication

Hi ,

I've setup the replication for db2 but at the end of the replcation ,
DB2 came out with the message error (see below) .

I have no idea why it shows me this error . I have two tablespaces ,
one for the system which has a pagesize of 4K and another one at 32K
for user . Each tablespace has 1 Gb .

Does someone have seen this ?

Regards

Andy the humble beginner in DB2 (better say the ignorant)

ps1: DB2 7.x and linux 7.x .

*** SQL ERROR ***: SQL1585N A system temporary table space with
sufficient page , size does not exist. SQLSTATE=54048

CDSET: SQL1 for fetching answerset: SELECT IBMSNAP_OPERATION,
IBMSNAP_INTENTSEQ, IBMSNAP_COMMITSEQ, "ID", "SHORT_NAME", "TYPE_FIC
HIER", "STRING_VALUE", "NUMERIC_VALUE", "DATE_VALUE", "BOOLEAN_VALUE",
"ID_DOCUMENT", "TIMESTAMP", "OBSERV_VALUE" FROM "REPSRC"."
CD_ATTR_INST" A , ASN.IBMSNAP_UOW WHERE ASN.IBMSNAP_UOW.IBMSNAP_UOWID
= A.IBMSNAP_UOWID AND ASN.IBMSNAP_UOW.IBMSNAP_COMMITSEQ >
? AND ASN.IBMSNAP_UOW.IBMSNAP_COMMITSEQ <= ? ORDER BY
IBMSNAP_COMMITSEQ ASC, A.IBMSNAP_INTENTSEQ ASC OPTIMIZE FOR 50000
ROWS.
CDSET: Prepare failed. errcode is 920101. sqlstate is 54048. sqlcode is
-1585
-------------------

Nov 12 '05 #1
9 13930
You need to create a system temporary tablespace with page size of 32K.

Nov 12 '05 #2
Hi ,

I did that .

create bufferpool plantestpool size 500 pagesize 32K;

CREATE TEMPORARY TABLESPACE TEMPSPACE1 pagesize 4k MANAGED BY DATABASE
USING (FILE '/opt/database/mongtest/temp02' 128000) EXTENTSIZE 80
bufferpool ibmdefaultbp;

CREATE USER TEMPORARY TABLESPACE TEMPSPACE2 pagesize 32k MANAGED BY
DATABASE USING (FILE
'/home/db2inst3/db2inst3/NODE0000/SQL00001/SQLOGDIR/data3.dbf' 32768)
EXTENTSIZE 80 bufferpool plantestpool;

GRANT USE OF TABLESPACE TEMPSPACE2 TO asn;

Any hints will be welcome.

Andy .

Nov 12 '05 #3
CREATE SYSTEM TEMPORARY TABLESPACE

Nov 12 '05 #4
Hi ,

I'm quite baffled and I'm wondering isn' it the "create temporary
tablespace" in itself a "create system temporary tablespace" ?

I'm gonna do the trick .

Thanks for your answers .

Regards ,
Andy

Nov 12 '05 #5
You are correct. The keyword SYSTEM is optional.

Nov 12 '05 #6
Ok m00... ,

I think I tried the trick but it doesn't seem to work the proper way .
Anyway , thanks for your answer .

Regards ,
Andy

Nov 12 '05 #7
Can you recreate your TEMPSPACE2 without the USER keyword? This
tablespace is for the Declared Global Temporary Table.

e.g.
CREATE TEMPORARY TABLESPACE TEMPSPACE2 pagesize 32k MANAGED BY
DATABASE USING (FILE
'/home/db2inst3/db2inst3/NODE0*000/SQL00001/SQLOGDIR/data3.db*f'
32768)
EXTENTSIZE 80 bufferpool plantestpool;

Nov 12 '05 #8
Hi ,

Done that again & again . I think i found something .

tell you more about this when i'll be done .

Thanks ,

Andy the beginner in db2 .

db2newbie a écrit :
Can you recreate your TEMPSPACE2 without the USER keyword? This
tablespace is for the Declared Global Temporary Table.

e.g.
CREATE TEMPORARY TABLESPACE TEMPSPACE2 pagesize 32k MANAGED BY
DATABASE USING (FILE
'/home/db2inst3/db2inst3/NODE0*000/SQL00001/SQLOGDIR/data3.db*f'
32768)
EXTENTSIZE 80 bufferpool plantestpool;


Nov 12 '05 #9
Hey everyone !

Thanks to all of you guys (should I mention db2newbie & m00) .

You were right . I needed a system tablespace with a pagesize of 32 k.

After that, my replcation was working and is still working fine .

Thanks !

Andy the humble beginner in DB2 .

ps: in case u need some documentation on DB2 , reply to me (don't let a
post) and i'll give you the data that I have on replication for db2 7.x
..

Andy K a écrit :
Hi ,

I've setup the replication for db2 but at the end of the replcation ,
DB2 came out with the message error (see below) .

I have no idea why it shows me this error . I have two tablespaces ,
one for the system which has a pagesize of 4K and another one at 32K
for user . Each tablespace has 1 Gb .

Does someone have seen this ?

Regards

Andy the humble beginner in DB2 (better say the ignorant)

ps1: DB2 7.x and linux 7.x .

*** SQL ERROR ***: SQL1585N A system temporary table space with
sufficient page , size does not exist. SQLSTATE=54048

CDSET: SQL1 for fetching answerset: SELECT IBMSNAP_OPERATION,
IBMSNAP_INTENTSEQ, IBMSNAP_COMMITSEQ, "ID", "SHORT_NAME", "TYPE_FIC
HIER", "STRING_VALUE", "NUMERIC_VALUE", "DATE_VALUE", "BOOLEAN_VALUE",
"ID_DOCUMENT", "TIMESTAMP", "OBSERV_VALUE" FROM "REPSRC"."
CD_ATTR_INST" A , ASN.IBMSNAP_UOW WHERE ASN.IBMSNAP_UOW.IBMSNAP_UOWID
= A.IBMSNAP_UOWID AND ASN.IBMSNAP_UOW.IBMSNAP_COMMITSEQ >
? AND ASN.IBMSNAP_UOW.IBMSNAP_COMMITSEQ <= ? ORDER BY
IBMSNAP_COMMITSEQ ASC, A.IBMSNAP_INTENTSEQ ASC OPTIMIZE FOR 50000
ROWS.
CDSET: Prepare failed. errcode is 920101. sqlstate is 54048. sqlcode is
-1585
-------------------


Nov 12 '05 #10

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

Similar topics

18
by: zebi | last post by:
hello, What's your opinion : The best type of temporary tablespace (DB2V7.2 SP 7 in AIX 4.3 / multiprocessor ) is DMS ou SMS ? Thanks ZEB
1
by: xixi | last post by:
There is one thing I don't understand, I have default tablespace userspace1 is database managed type, with total freepages 506048. another one called tmpxx is DMS type too, with 525120 free pages....
2
by: Pattnayak | last post by:
Hi, when i am trying to create a table in Db2, and specifies the tablespace as default,it gives an error saying "There is no default tablespace".Can anybody please help me out to assign a...
5
by: N | last post by:
Hi, I got an error during load on a couple of the tables. And it seems to be complaining that I'm running out of tempspace (possibly during index rebuild). Below is the load command and error....
3
by: Joe Weinstein | last post by:
Hi all. I am debugging a JDBC application. I find that a certain query that has an order-by clause fails with a SQL1585N A system temporary table space with sufficient page size does not exist....
6
by: gimme_this_gimme_that | last post by:
I'm new to DB2 ... The following statement results in a SQL1585N message : "A system temporary table space with sufficient page size does not exist" Note that the column FIELD_DETAIL is a...
11
by: rawu | last post by:
hi , all . I got a question about creating indexes in db2 . a table has 44236333 rows an index planed to be build include 2 field ( 6 byte ) accordding to db2 document temporary...
4
by: sandeep.iitk | last post by:
Hi, One query is failing on the database and its a long query which was running fine earlier. One possible reason we can think of is increase in data in tables in query. It is failing with...
6
by: Troels Arvin | last post by:
Hello, I have recently run a rather large data import where the imported data i pumped through some updatable views equipped with INSTEAD OF triggers. For various reasons, the exact same data...
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, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
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: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

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.