473,411 Members | 2,031 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,411 software developers and data experts.

Raw Device

Hi
Is there any limit on size of raw device container (4GB etc) in db2 luw v8.1 fixpak 9?

Regards
Saurabh
Apr 17 '08 #1
2 1764
docdiesel
297 Expert 100+
Hi,

the maximum of tablespace size depends on the pages size. Using 4K pages, the DMS containers size may use up to 2 TB.

Which OS is your DB2 installed on? Is OS and DB2 32bit or 64bit?

Regards,

Bernd
Apr 21 '08 #2
Hello,

You are limited only with the destination disk space (device space) up to 2TB (as docdiesel said) ... and optionally by bufferpool assigned (operating memory - you cannot load e.g. 2TB table in one piece)

you can setup the pagesize up to 64k (depends on system) and then count your available space divided by 65536 (I hope - my system dont support it) or the highest available for your system (1k = 1024)
May 12 '08 #3

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

Similar topics

8
by: nek | last post by:
Greetings, Has anyone got the latest progress on this? It hit me this time on W2K running DB2 V8.1.5. It returned the following warning: D:\Temp>db2 backup db sample to \\localhost\tape0...
5
by: tech.witch | last post by:
I'm doing a postmortem from an outage at my workplace that looks too similar to an outage we had last fall to not be related. Both database outages had the following characteristics: 1) VERY...
22
by: Jan Richter | last post by:
Hi there, the Code below shows DJBs own implementation of strlen (str_len): unsigned int str_len(char *s) { register char *t; t = s; for (;;) { if (!*t) return t - s; ++t;
12
by: Steve | last post by:
I wrote a simple virtual device driver int15.sys, Is C# support load the device driver from AP?
8
by: Tony Liu | last post by:
I am having a "Null Device is Missing" compile error when compiling a c++ project. The documentation from MSDN said it could be caused by low system resource or the user account does not have...
7
by: Ritu | last post by:
Hi All, Can any body please tell me how i can write a device driver using CSharp. Thanks, Ritu
2
by: Rosalind Chen | last post by:
Hi, This is the first time that I use Visual Studio .NET. And I stucked in this first problem. - I created a SDK from Platform builder 4.2 that includes .Net Compact Framework. - installed...
8
by: Konstantin Andreev | last post by:
Hello. I'm experiencing very disagreeable problem: DB2 refuses tablespace containers, which are DEVICE's bigger than 4G. So, If I below 4G limit: | # db2 create tablespace TS1 pagesize 4096...
0
by: Shival | last post by:
Hi, I have a Device that will be used by dentist to take their paitient teaath pics. this Device is having a click button from which the device takes pics. The Device is configured to my OS...
0
by: dagobert2000 | last post by:
Hi! First of all, I'm using a the latest Version of a FUSD Module...for my device-driver. I have the following situation: I have a PPP connection over a serial (RFCOMM-)device. That works...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.