473,890 Members | 1,360 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L

Hello,

I am preparing a database that will store 10 n * GBs - 100 n * GBs of data.

I calculated to have 1,2 GB of bufferpools. I run the DB2 v. 8.2.1 alone on
4 GB box.

I obtain :

"SQL1478W The defined buffer pools could not be started. Instead, one small
buffer pool for each page size supported by DB2 has been started.
SQLSTATE=01626"

when trying to start database with desires bufferpool sizes.

my "svmon -G" shows 411635 * 4 kB = 1,57 GB of free physical RAM.

I enclose the complete information for someone who would be able to help me.

CREATING:
############### ############### ##

db2 -v "CREATE DATABASE LODB ON /u01/dbfiles USING CODESET UTF-8 TERRITORY
PL COLLATE USING SYSTEM CATALOG TABLESPACE MANAGED BY SYSTEM USING (
'/u01/dbfiles/dbcont/syscon' ) USER TABLESPACE MANAGED BY SYSTEM USING (
'/u01/dbfiles/dbcont/usrcon') TEMPORARY TABLESPACE MANAGED BY SYSTEM USING
('/u01/dbfiles/dbcont/tmpcon' )"

sleep 10

db2 -v "CONNECT TO LOGDB""

# Utworzenie potrzebnych BUFFERPOOLS"

# 76800 * 4 kB = 300 MB"
db2 -v "CREATE Bufferpool SYBP IMMEDIATE SIZE 76800 PAGESIZE 4 K "

# 307200 * 4 kB = 1200 MB"
# 38400 * 32 kB = 1200 MB"
db2 -v "CREATE Bufferpool USRBP IMMEDIATE SIZE 38400 PAGESIZE 32 K "

# 76800 * 4 kB = 300 MB"
db2 -v "CREATE Bufferpool TEMPBP IMMEDIATE SIZE 76800 PAGESIZE 4 K "

# 153600 * 4 kB = 600 MB"
# 38400 * 16 kB = 600 MB"
db2 -v "CREATE Bufferpool IDXBP IMMEDIATE SIZE 38400 PAGESIZE 16 K "

# Razem na Booferpools 2400 MB"
# Utworzenie PODSTAWOWEGO TABLESPACE dla USER"

db2 -v "CREATE REGULAR TABLESPACE USRSPACE PAGESIZE 32 K MANAGED BY
DATABASE USING ( FILE '/u01/dbfiles/dbcont/usrcon1/u1' 65536 ) EXTENTSIZE
16 OVERHEAD 10.5 PREFETCHSIZE 40 TRANSFERRATE 0.14 BUFFERPOOL USRBP DROPPED
TABLE RECOVERY OFF "
db2 -v "COMMENT ON TABLESPACE USRSPACE IS 'USRSPACE'"

sleep 10

# Utworzenie dodatkowego TABLESPACE dla indeksow"

db2 -v "CREATE REGULAR TABLESPACE INDEXSPACE PAGESIZE 16 K MANAGED BY
DATABASE USING ( FILE '/u01/dbfiles/dbcont/idx1/i1' 65536 ) EXTENTSIZE 16
OVERHEAD 10.5 PREFETCHSIZE 40 TRANSFERRATE 0.14 BUFFERPOOL IDXBP DROPPED
TABLE RECOVERY OFF "
db2 -v "COMMENT ON TABLESPACE INDEXSPACE IS 'INDEXSPACE'"

sleep 10
# Utworzenie dodatkowego TABLESPACE dla CLOBow"

# Podobno dla CLOBow nie definiujemy pagesize ani dodatkowego bufferpoola"

db2 -v "CREATE LARGE TABLESPACE CLOBSPACE PAGESIZE 32 K MANAGED BY
DATABASE USING ( FILE '/u01/dbfiles/dbcont/clob1/c1' 262144 ) EXTENTSIZE 64
OVERHEAD 10.5 PREFETCHSIZE 80 TRANSFERRATE 0.14 BUFFERPOOL USRBP DROPPED
TABLE RECOVERY OFF"
db2 -v "COMMENT ON TABLESPACE CLOBSPACE IS 'CLOBSPACE'"

sleep 10
# Dodnie kontenerow do USERSPACE i CLOBSPACE"

# stałe dla specyfikowania rozmiarów"

# 524288 * 8 kB = 4 GB dla CLOB "
# 262144 * 32 kB = 8 GB dla CLOB "
# 524288 * 4 kB = 2 GB dla USR "
# 262144 * 4 kB = 1 GB dla IDX "

# 65536 * 32 kB = 2 GB dla USR "
# 32768 * 32 kB = 1 GB dla IDX "
# 65536 * 16 kB = 1 GB dla IDX "

db2 -v "ALTER TABLESPACE USRSPACE ADD ( FILE
'/u01/dbfiles/dbcont/usrcon1/u2' 65536 )"
sleep 10

db2 -v "ALTER TABLESPACE CLOBSPACE ADD ( FILE '/u01/dbfiles/dbcont/clob1/c2'
262144 )"
sleep 10

db2 -v "ALTER TABLESPACE INDEXSPACE ADD ( FILE '/u01/dbfiles/dbcont/idx1/i2'
65536 )"
sleep 10

db2 -v "ALTER TABLESPACE USRSPACE ADD ( FILE
'/u01/dbfiles/dbcont/usrcon1/u3' 65536 )"
sleep 10

db2 -v "ALTER TABLESPACE CLOBSPACE ADD ( FILE '/u01/dbfiles/dbcont/clob1/c3'
262144 )"
sleep 10

db2 -v "ALTER TABLESPACE INDEXSPACE ADD ( FILE '/u01/dbfiles/dbcont/idx1/i3'
65536 )"
sleep 10

db2 -v "ALTER TABLESPACE USRSPACE ADD ( FILE
'/u01/dbfiles/dbcont/usrcon1/u4' 65536 )"
sleep 10

db2 -v "ALTER TABLESPACE CLOBSPACE ADD ( FILE '/u01/dbfiles/dbcont/clob1/c4'
262144 )"
sleep 10

db2 -v "ALTER TABLESPACE INDEXSPACE ADD ( FILE '/u01/dbfiles/dbcont/idx1/i4'
65536 )"
sleep 10

# Przypisanie BUFFERPOOLS do TABLESPAC'ow"

db2 -v "ALTER TABLESPACE SYSCATSPACE BUFFERPOOL SYBP"
db2 -v "ALTER TABLESPACE TEMPSPACE1 BUFFERPOOL TEMPBP"

db2 -v "CREATE DATABASE LOGDB ON /u01/dbfiles USING CODESET UTF-8 TERRITORY
PL COLLATE USING SYSTEM CATALOG TABLESPACE MANAGED BY SYSTEM USING (
'/u01/dbfiles/dbcont/syscon' ) USER TABLESPACE MANAGED BY SYSTEM USING (
'/u01/dbfiles/dbcont/usrcon') TEMPORARY TABLESPACE MANAGED BY SYSTEM USING
('/u01/dbfiles/dbcont/tmpcon' )"

sleep 10

db2 -v "CONNECT TO LOGDB""

# Utworzenie potrzebnych BUFFERPOOLS"

# 76800 * 4 kB = 300 MB"
db2 -v "CREATE Bufferpool SYBP IMMEDIATE SIZE 76800 PAGESIZE 4 K "

# 307200 * 4 kB = 1200 MB"
# 38400 * 32 kB = 1200 MB"
db2 -v "CREATE Bufferpool USRBP IMMEDIATE SIZE 38400 PAGESIZE 32 K "

# 76800 * 4 kB = 300 MB"
db2 -v "CREATE Bufferpool TEMPBP IMMEDIATE SIZE 76800 PAGESIZE 4 K "

# 153600 * 4 kB = 600 MB"
# 38400 * 16 kB = 600 MB"

TUNING
############### ############### ####

--------------------------
-- STROJENIE BAZY DANYCH
--------------------------
-- Parametry menedzera bazy danych

update dbm cfg using NUMDB 2
update dbm cfg using NOTIFYLEVEL 2

update dbm cfg using DFT_MON_BUFPOOL ON
update dbm cfg using DFT_MON_LOCK ON
update dbm cfg using DFT_MON_SORT ON
update dbm cfg using DFT_MON_STMT ON
update dbm cfg using DFT_MON_TABLE ON
update dbm cfg using DFT_MON_TIMESTA MP ON

update dbm cfg using QUERY_HEAP_SZ 2000

update dbm cfg using NUM_POOLAGENTS 60
update dbm cfg using NUM_INITAGENTS 50

update dbm cfg using DIAGPATH /u01/dbfiles/diag

-- Parametry bazy danych LOGDB

update db cfg for logdb using DBHEAP 9600
update db cfg for logdb using LOCKLIST 3000
update db cfg for logdb using APP_CTL_HEAP_SZ 256
update db cfg for logdb using SORTHEAP 2048
update db cfg for logdb using APPLHEAPSZ 1024
update db cfg for logdb using PCKCACHESZ 3000
update db cfg for logdb using MAXLOCKS 5
update db cfg for logdb using LOCKTIMEOUT 60

update db cfg for logdb using NUM_IOCLEANERS 9
update db cfg for logdb using NUM_IOSERVERS 12

update db cfg for logdb using MAXAPPLS 50
update db cfg for logdb using AVG_APPLS 50
update db cfg for logdb using MAXFILOP 128

-- tworzymy 120 plikow logow transakcyjnych kazdy po 2560 * 4 kB = 10 MB
update db cfg for logdb using LOGFILSIZ 2560
update db cfg for logdb using LOGPRIMARY 120
update db cfg for logdb using LOGSECOND 0
update db cfg for logdb using LOGRETAIN RECOVERY

-- rozmiar bufora logow 2560 * 4 kB = 10 MB
update db cfg for logdb using LOGBUFSZ 2560
update db cfg for logdb using NEWLOGPATH /db2arch

--update db cfg for logdb using MINCOMMIT 2

CONNECT RESET
db2 get dbm cfg
############### ###

bash-2.05b$ db2 get dbm cfg

Database Manager Configuration

Node type = Database Server with local and remote clients

Database manager configuration release level = 0x0a00

CPU speed (millisec/instruction) (CPUSPEED) = 4.251098e-07

Max number of concurrently active databases (NUMDB) = 2
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =

Default charge-back account (DFT_ACCOUNT_ST R) =

Java Development Kit installation path (JDK_PATH) = /usr/java131

Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 2
Diagnostic data directory path (DIAGPATH) = /u01/dbfiles/diag

Default database monitor switches
Buffer pool (DFT_MON_BUFPOO L) = ON
Lock (DFT_MON_LOCK) = ON
Sort (DFT_MON_SORT) = ON
Statement (DFT_MON_STMT) = ON
Table (DFT_MON_TABLE) = ON
Timestamp (DFT_MON_TIMEST AMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = OFF

SYSADM group name (SYSADM_GROUP) = DB2GRP1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP ) =
SYSMON group name (SYSMON_GROUP) =

Client Userid-Password Plugin (CLNT_PW_PLUGIN ) =
Client Kerberos Plugin (CLNT_KRB_PLUGI N) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGI N) =
Server Plugin Mode (SRV_PLUGIN_MOD E) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUG IN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUG IN) =
Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Database manager authentication (AUTHENTICATION ) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH ) = NO
Trust all clients (TRUST_ALLCLNTS ) = YES
Trusted client authentication (TRUST_CLNTAUTH ) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO

Default database path (DFTDBPATH) =
/u01/home/db2inst1

Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMOR Y) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024

Sort heap threshold (4KB) (SHEAPTHRES) = 20000

Directory cache support (DIR_CACHE) = YES

Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 2000

Workload impact by throttled utilities(UTIL_ IMPACT_LIM) = 10

Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 200
Agent pool size (NUM_POOLAGENTS ) = 60
Initial number of agents in pool (NUM_INITAGENTS ) = 50
Max number of coordinating agents (MAX_COORDAGENT S) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTION S) = MAX_COORDAGENTS

Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED ) = 0

Index re-creation time and redo index build (INDEXREC) = RESTART

Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVA L) = 180

SPM name (SPM_NAME) = csdbaza
SPM log size (SPM_LOG_FILE_S Z) = 256
SPM resync agent limit (SPM_MAX_RESYNC ) = 20
SPM log path (SPM_LOG_PATH) =

TCP/IP Service name (SVCENAME) = db2c_db2inst1
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE

Maximum query degree of parallelism (MAX_QUERYDEGRE E) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL ) = NO

No. of int. communication buffers(4KB)(FC M_NUM_BUFFERS) = 1024
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNEC T) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHOR S) = AUTOMATIC
db2 get db cfg for lodb
############### ######

bash-2.05b$ db2 get db cfg for logdb

Database Configuration for Database logdb

Database configuration release level = 0x0a00
Database release level = 0x0a00

Database territory = PL
Database code page = 1208
Database code set = UTF-8
Database country/region code = 48
Database collating sequence = BINARY
Alternate collating sequence (ALT_COLLATE) =

Dynamic SQL Query management (DYN_QUERY_MGMT ) = DISABLE

Discovery support for this database (DISCOVER_DB) = ENABLE

Default query optimization class (DFT_QUERYOPT) = 5
Degree of parallelism (DFT_DEGREE) = 1
Continue upon arithmetic exceptions (DFT_SQLMATHWAR N) = NO
Default refresh age (DFT_REFRESH_AG E) = 0
Default maintained table types for opt (DFT_MTTB_TYPES ) = SYSTEM
Number of frequent values retained (NUM_FREQVALUES ) = 10
Number of quantiles retained (NUM_QUANTILES) = 20

Backup pending = NO

Database is consistent = YES
Rollforward pending = NO
Restore pending = NO

Multi-page file allocation enabled = YES

Log retain for recovery status = RECOVERY
User exit for logging status = NO

Data Links Token Expiry Interval (sec) (DL_EXPINT) = 60
Data Links Write Token Init Expiry Intvl(DL_WT_IEX PINT) = 60
Data Links Number of Copies (DL_NUM_COPIES) = 1
Data Links Time after Drop (days) (DL_TIME_DROP) = 1
Data Links Token in Uppercase (DL_UPPER) = NO
Data Links Token Algorithm (DL_TOKEN) = MAC0

Database heap (4KB) (DBHEAP) = 9600
Size of database shared memory (4KB) (DATABASE_MEMOR Y) = AUTOMATIC
Catalog cache size (4KB) (CATALOGCACHE_S Z) = (MAXAPPLS*4)
Log buffer size (4KB) (LOGBUFSZ) = 2560
Utilities heap size (4KB) (UTIL_HEAP_SZ) = 5000
Buffer pool size (pages) (BUFFPAGE) = 1000
Extended storage segments size (4KB) (ESTORE_SEG_SZ) = 16000
Number of extended storage segments (NUM_ESTORE_SEG S) = 0
Max storage for lock list (4KB) (LOCKLIST) = 3000

Max size of appl. group mem set (4KB) (APPGROUP_MEM_S Z) = 30000
Percent of mem for appl. group heap (GROUPHEAP_RATI O) = 70
Max appl. control heap size (4KB) (APP_CTL_HEAP_S Z) = 256

Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR ) = (SHEAPTHRES)
Sort list heap (4KB) (SORTHEAP) = 2048
SQL statement heap (4KB) (STMTHEAP) = 2048
Default application heap (4KB) (APPLHEAPSZ) = 1024
Package cache size (4KB) (PCKCACHESZ) = 3000
Statistics heap size (4KB) (STAT_HEAP_SZ) = 4384

Interval for checking deadlock (ms) (DLCHKTIME) = 10000
Percent. of lock lists per application (MAXLOCKS) = 5
Lock timeout (sec) (LOCKTIMEOUT) = 60

Changed pages threshold (CHNGPGS_THRESH ) = 60
Number of asynchronous page cleaners (NUM_IOCLEANERS ) = 9
Number of I/O servers (NUM_IOSERVERS) = 12
Index sort flag (INDEXSORT) = YES
Sequential detect flag (SEQDETECT) = YES
Default prefetch size (pages) (DFT_PREFETCH_S Z) = AUTOMATIC

Track modified pages (TRACKMOD) = OFF

Default number of containers = 1
Default tablespace extentsize (pages) (DFT_EXTENT_SZ) = 32

Max number of active applications (MAXAPPLS) = 50
Average number of active applications (AVG_APPLS) = 50
Max DB files open per application (MAXFILOP) = 128

Log file size (4KB) (LOGFILSIZ) = 2560
Number of primary log files (LOGPRIMARY) = 30
Number of secondary log files (LOGSECOND) = 0
Changed path to log files (NEWLOGPATH) =
Path to log files = /db2arch/
Overflow log path (OVERFLOWLOGPAT H) =
Mirror log path (MIRRORLOGPATH) =
First active log file = S0000007.LOG
Block log on disk full (BLK_LOG_DSK_FU L) = NO
Percent of max active log space by transaction(MAX _LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPA N) = 0

Group commit count (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 100
Log retain for recovery enabled (LOGRETAIN) = RECOVERY
User exit for logging enabled (USEREXIT) = OFF

HADR database role = STANDARD
HADR local host name (HADR_LOCAL_HOS T) =
HADR local service name (HADR_LOCAL_SVC ) =
HADR remote host name (HADR_REMOTE_HO ST) =
HADR remote service name (HADR_REMOTE_SV C) =
HADR instance name of remote server (HADR_REMOTE_IN ST) =
HADR timeout value (HADR_TIMEOUT) = 120
HADR log write synchronization mode (HADR_SYNCMODE) = NEARSYNC

First log archive method (LOGARCHMETH1) = LOGRETAIN
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =
Failover log archive path (FAILARCHPATH) =
Number of log archive retries on error (NUMARCHRETRY) = 5
Log archive retry Delay (secs) (ARCHRETRYDELAY ) = 20
Vendor options (VENDOROPT) =

Auto restart enabled (AUTORESTART) = ON
Index re-creation time and redo index build (INDEXREC) = SYSTEM (RESTART)
Log pages during index build (LOGINDEXBUILD) = OFF
Default number of loadrec sessions (DFT_LOADREC_SE S) = 1
Number of database backups to retain (NUM_DB_BACKUPS ) = 12
Recovery history retention (days) (REC_HIS_RETENT N) = 366

TSM management class (TSM_MGMTCLASS) =
TSM node name (TSM_NODENAME) =
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) =

Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP ) = OFF
Automatic table maintenance (AUTO_TBL_MAINT ) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statistics profiling (AUTO_STATS_PRO F) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF


Nov 12 '05
22 5603
Smutny30 wrote:

I have now my 64-bit DB2 instance up and runing, and allocating all 2,4 GB
for bufferpools. Great appreciation for all the people that helped me to
solve it.

sincerely Olek


Plz. post solution, may help a lot of people who are stuck.

-R-

Nov 12 '05 #21
"Jurgen Haan" <ju****@fake.do m> wrote in message
news:42******** *************@n ews.xs4all.nl.. .
I have now my 64-bit DB2 instance up and runing, and allocating all 2,4
GB for bufferpools. Great appreciation for all the people that helped me
to solve it.

sincerely Olek


Plz. post solution, may help a lot of people who are stuck.

-R-

The solution was to create a 64 bit instance instead of a 32 bit instance.
That way, the limit on the amount of memory that a DB2 instance can use is
no longer restricted to 1.75 GB for AIX (limit depends on OS).
Nov 12 '05 #22
Mark A wrote:
"Jurgen Haan" <ju****@fake.do m> wrote in message
news:42******** *************@n ews.xs4all.nl.. .
I have now my 64-bit DB2 instance up and runing, and allocating all 2,4
GB for bufferpools. Great appreciation for all the people that helped me
to solve it.

sincerely Olek


Plz. post solution, may help a lot of people who are stuck.

-R-


The solution was to create a 64 bit instance instead of a 32 bit instance.
That way, the limit on the amount of memory that a DB2 instance can use is
no longer restricted to 1.75 GB for AIX (limit depends on OS).


Ah... apologies. Due to the seperate post in the thread I thought it was
solved by different means than the mere 32 -> 64 bit conversion.

-R-
Nov 12 '05 #23

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

Similar topics

8
5490
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- Hello, I have a very simple problem but cannot seem to figure it out. I have a very simple php script that sends a test email to myself. When I debug it in PHP designer, it works with no problems, I get the test email. If
10
4483
by: Jean-David Beyer | last post by:
I have some programs running on Red Hat Linux 7.3 working with IBM DB2 V6.1 (with all the FixPacks) on my old machine. I have just installed IBM DB2 V8.1 on this (new) machine running Red Hat Enterplise Linux 3 ES, and applied FixPack fp5_mi00069.tar to it. After creating an instance, starting the database, creating a database, and entering the table definitions, all of which seems to work OK, I entered a tiny 8-row table and can do...
1
1834
by: p175 | last post by:
Can anyone please explain in english the difference between blocked and non-pages in a bufferpool. What would be a typical ration one would use for say a 100,000 4kb size BP. 50/50 blocked v unblocked ?
1
6649
by: Peter | last post by:
I've purchased VS.NET 2005 Standard and have tried to install SQL Server 2005 Express, but get the following error in the error log. Please could someone help me.... Microsoft SQL Server 2005 Express Edition x86: Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***? Microsoft SQL Server 2005 Express Edition x86: Component Microsoft SQL Server 2005 Express Edition x86 returned an...
3
16535
by: David T. Ashley | last post by:
Hi, Red Hat Enterprise Linux 4.X. I'm writing command-line PHP scripts for the first time. I get the messages below. What do they mean? Are these operating system library modules, or something in PHP that I don't have? Do I need to install more Linux packages? Or adjust PHP in some way?
1
410
by: rAinDeEr | last post by:
Hi, Am trying to create the DDL statements of a database using $ db2look -d TESTDB -e -z db2tar -i testiii -w test123 -m -o db2look.sql I get all the useful information except that of the Bufferpools and Tablespaces.... Is there any other alternative to get the DDL of the bufferpools and Tablespaces ??
1
4640
by: vsp15584 | last post by:
Hii..i use the coding as below :- import java.applet.applet; import java.awt.*; import com.sun.j3d.utils.applet.mainframe; import com.sun.j3d.utils.universe.*; import com.sun.j3d.utils.geometry.*; import javax.media.j3d.*; import javax.vecmath.*;
0
1151
by: vidya panicker | last post by:
Hi, is there a specific number of bufferpools in UDB version 7.1 or is it a user decidable variable?
3
17133
by: amanjsingh | last post by:
Hi, I am trying to implement Java Web Service using Apache Axis2 and Eclipse as a tool. I have created the basic code and deployed the service using various eclipse plugin but when I try to invoke the service using client stub, I get this error... Exception in thread "main" java.lang.Error: Unresolved compilation problems: org.apache cannot be resolved to a type org.apache cannot be resolved to a type org.apache cannot be resolved to a...
0
11236
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10830
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10925
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
8018
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7172
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5855
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6061
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4276
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3283
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.