| Looking for scenario simulation tools for Oracle |
|
 |
Index ‹ database
|
- Previous
- 2
- Problem with sequence in UDB 8.2
Folks,
I am having problem running select query from a sequence. I get SQL0204N
error. I am running UDB 8.2 on AIX 5.2.
# oslevel
5.2.0.0
# db2level
DB21085I Instance "dba2test" uses "32" bits and DB2 code release "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.1.80", "s041221", "U800400", and FixPak "8".
Product is installed at "/usr/opt/db2_08_01".
# db2 -svtf ~/tmp/w
CREATE SEQUENCE A2TEST.NEXTFRAGNUM AS INTEGER MINVALUE 1032 MAXVALUE 2147483647 START WITH 1032 INCREMENT BY 1 CACHE 20 NO CYCLE ORDER
DB20000I The SQL command completed successfully.
# db2 "SELECT NEXT_NUMBER FROM A2TEST.NEXTFRAGNUM FOR UPDATE OF NEXT_NUMBER"
SQL0204N "A2TEST.NEXTFRAGNUM" is an undefined name. SQLSTATE=42704
What am I doing wrong?
The above SQL statements works fine on a UDB 7.2 database.
--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: email***@***.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
- 2
- CREATE ASSERTION in future? CHECK subselect?I've been hitting the DB books lately and I was wondering if anyone knows
where features like "CREATE ASSERTION" and sub-selects in CHECK
constraints stand in the TODO queue for production PgSQL. Are they even in
development at all? Or have they been written off as too expensive? I did
see somewhere that a developer version of the Pg server could be built
with CREATE ASSERTION enabled but that was NOT recommended for production
installs.
Also what is the status of CREATE DOMAIN?
Just wonderin'
--
+--------------------------------------------------------------------+
| G. Brannon SMITH, M.S. WWW: http://gbsmith.freeshell.org |
| Computer Science mailto:gbsmithATfreeshellDOTorg |
| mailto:brannonsmithATyahooDOTcom |
+--------------------------------------------------------------------+
| "There is no off position on the genius switch." - David Letterman |
+--------------------------------------------------------------------+
- 2
- small bug in op + between datetime and integer
Anyone have an idea on this one?
---------------------------------------------------------------------------
Pavel Stehule wrote:
> Hello
>
> It is maybe not bug, but I didn't find any warning about this behavior.
>
> select current_date + 1; -- ok
> select 1 + current_date; -- not
>
> ERROR: operator does not exist: integer + date
> HINT: No operator matches the given name and argument type(s). You may
> need to add explicit typecasts.
>
> I use CVS version of PostgreSQL from last week
>
> regards
>
> Pavel Stehule
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
--
Bruce Momjian | http://candle.pha.pa.us
email***@***.com | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
- 2
- Understanding Navigator output for DB2 i/Series 5r3Hi,
I'm using Navigator to review performance monitors for a system under
test and finding the 'statement usage count' confusing.
The column doesn't seem to be a count of the times the statement was
actually executed (as I had thought it would be), nor does it map
clearly to 'steps' in a statement (same statement run once only does
not always produce the same count).
I've had a hunt through the Information Centre manuals and whilst this
column is mentioned a number of times it is usually just to say it
exists or to map it onto QQCNT.
Does anyone know for sure what this column is really telling me or can
they point me at another reference point than Information Centre which
is reliable for this type of information? Without a clear understanding
of where this number comes from I'm not sure if there is a bug in the
reporting or how reliable the output actually is.
i/Series is not my home platform so if I'm missing something obvious
please tell me - there seems to be a lot less informal discussion/web
resources about this platform than *nix or z/os!
TIA,
--
Karen
- 3
- Continous increase in insertion rate with time!!!Hi Group,
I am finding an increase in insertion rate with time with steady
insertion and updation rate of 70 records per sec with my app using
Postgres 7.4.5 on Solaris 5.8.
I am using Postgres7.4.5 on solaris5.8 (1-Gig Ram) machine.
During the initial stages say Ist 1hr or so, the insertion rate is about
5 sec per insert but it slowly starts building up with time and after 24
hour goes to 12-15 sec and after 48hr goes to 25 sec. Update is fast and
is in less than a sec.
I have attached the postgres conf file and the statistics collected
during the run.
Is this a known feature (or limitation). How can I avoid this by
minimising the disk read?
Shld I consider updating postgresql.conf with more appropriate values.
(i.e disabling fysnc and check pointing based on chkpoint timeout as I
perform continous insert -> update and then batch delete)
****************************************
postgresql.conf
****************************************
max_connections = 100
shared_buffers = 32000 #(Org 1000)
sort_mem = 8192 #(Org 1024)
fsync = true
wal_sync_method = fsync
wal_buffers = 8
checkpoint_segments = 10 #(Org 3)
effective_cache_size = 1000
****************************************
cdr_backup=# select * from pg_stat_user_tables;
relid | schemaname | relname | seq_scan |
seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd |
n_tup_del
---------+--------------------+-------------------------+----------+----
----------+----------+---------------+-----------+-----------+----------
-
9471204 | public | cdr | 41069 |
39957057 | 1 | 0 | 19056991 | 0 | 19054378
9471214 | public | cdr_archive | 2327 |
23331784 | 492714 | 19233822 | 19054379 | 0 | 19031842
cdr_backup=# select * from pg_stat_user_indexes;
relid | indexrelid | schemaname | relname |
indexrelname | idx_scan | idx_tup_read | idx_tup_fetch
---------+------------+------------+-----------------+------------------
--------------+----------+--------------+---------------
9471214 | 9471222 | public | cdr_archive |
cdr_archive_accesstime_key | 492785 | 19233822 | 19233822
9471204 | 9471212 | public | cdr | cdr_transid_key
| 1 | 0 | 0
cdr_backup=# select * from pg_statio_user_indexes;
relid | indexrelid | schemaname | relname |
indexrelname | idx_blks_read | idx_blks_hit
---------+------------+------------+-----------------+------------------
--------------+---------------+--------------
9471214 | 9471222 | public | cdr_archive |
cdr_archive_accesstime_key | 1472 | 73638177
9471204 | 9471212 | public | cdr | cdr_transid_key
| 934 | 58408992
cdr_backup=# select * from pg_statio_user_indexes;
relid | indexrelid | schemaname | relname |
indexrelname | idx_blks_read | idx_blks_hit
---------+------------+------------+-----------------+------------------
--------------+---------------+--------------
9471214 | 9471222 | public | cdr_archive |
cdr_archive_accesstime_key | 1472 | 73638267
9471204 | 9471212 | public | cdr | cdr_transid_key
| 934 | 58408992
(4 rows)
cdr_backup=# select * from pg_statio_user_tables;
relid | schemaname | relname | heap_blks_read
| heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read |
toast_blks_hit | tidx_blks_read | tidx_blks_hit
---------+--------------------+-------------------------+---------------
-+---------------+---------------+--------------+-----------------+-----
-----------+----------------+---------------
9471204 | public | cdr | 19912
| 137570556 | 934 | 58408992 | 76 |
1318 | 2 | 1226
9471214 | public | cdr_archive | 222246
| 112726711 | 1472 | 73638408 | 122 |
2316 | 2 | 4511
Thanks,
Rajan
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
- 5
- show comments for columns ...Hello,
I need help generating a sql statement for showing columns and comments
of a table.
Something like:
db2 select columname,comment from dontknow where tablename='table'
Thanks for your support
Dirk
- 5
- add to (secondary databases (no need to answer my previous question, please help with this)) mailhi.
pufffff.me again.i guess you get bored with me,sorry :\ i wish this
will be the last question to you.
i wrote secondary db search (show_item function) works well with the
"zulu nut" in my previous mail but not,i mixed it up.it doesn`t work
well with anything.but it works well with
show_all_records(itemnameSDB, vendorDB). i change the first
parameter,i put itemnameSDB instead of inventoryDB.i put a line and i
put a breakpoint to that /**/ line.
while ((ret = cursorp->get(&key, &data, DB_NEXT)) == 0 )
{
/**/ cout << string((char*)key.get_data());
InventoryData inventoryItem(data.get_data());
inventoryItem.show();
show_vendor(vendorDB, inventoryItem.getVendor().c_str());
}
and it writes the key wrong something like this: ||||22221
but when i change the first parameter like this:
show_all_records(inventoryDB, vendorDB) it writes the key truely.
i mean in show_all_records function; when the first parameter is
inventoryDB, key is right but when the first parameter is itemnameSDB,
key is wrong.
well what should i do to fix it.
thank you already.
- 5
- Core Dump in sqleatin_api on UDB 8.1Hi All,
I am seeing a problem with a UDB client application(multi-threaded)
that uses the UDB client libraries(libdb2.so) on solaris. I see a core
dump that points to the routine sqleatin_api. Enclosed is the stack
trace. Is anybody facing a similar issue with UDB? Please do let me
know. Thanks in advance.
(/swapps/spro/5.0/SUNWspro/bin/../WS5.0/bin/sparcv9/dbx) where
current thread: t@80
[1] sqlccipcrecv(0x7c638, 0x7b802, 0x0, 0x0, 0x0, 0x1), at
0xfe118134
[2] sqlccrecv(0x7c638, 0x7c968, 0x0, 0xfeb036ac, 0x0, 0x66), at
0xfe11363c
[3] sqljcReceive(0x7b802, 0xfcc0f0de, 0xfe6b25a0, 0x1400,
0xfe53a424, 0x1), at 0xfe242588
[4] sqljrDrdaArAuthenticate(0x7bfe8, 0x2, 0xfeb038ec, 0x1, 0x7b548,
0xfe3a3140), at 0xfe299f3c
[5] sqlexAppAuthenticate(0x7bfe8, 0x2, 0xfe53a424, 0x0, 0x79ed8,
0x40000000), at 0xfe17ea00
[6] sqljrDrdaArAttach(0x7bfe8, 0xd0, 0xfe66fb5c, 0xfe17e274,
0xfe5599e0, 0xfe53a424), at 0xfe275354
[7] sqleUCdrdaARinit(0x79d28, 0x1, 0xc00, 0xfe66faf4, 0xee0,
0xfe66fcd8), at 0xfe15953c
[8] sqleUCappAttach(0x79d28, 0xfeb03d40, 0xfeb03fe8, 0xfe66fa88,
0x5, 0xfe6b25a0), at 0xfde62ab0
[9] sqleatin(0x79d28, 0x6, 0x5, 0x79d28, 0xfeb03d40, 0x68318), at
0xfde2bb30
[10] sqleatcp_api(0xaa798, 0xaab98, 0xaac18, 0x0, 0xfeb03fe8,
0xfe35b379), at 0xfde2e754
[11] sqleatin_api(0xaa798, 0xaab98, 0xaac18, 0xfeb03fe8, 0x0,
0xfeb04071), at 0xfde2e2bc
The parameters into the call are all valid. I did check the parameters
under the debugger. None of them are null pointers. Everyting is
valid. Also we are running with the latest fixpak.
Thanks,
Narasimha Krishnakumar.
- 5
- Moving SQLJ Stored ProceduresI have created ~30 stored procedures that I need to have running on a
database in order to use the application that I have developed. I am
looking for a solution so that these stored procedures can be imported
by other people with the least amount of work.
I have been exporting the stored procedures from the DB2 Development
Center to a zip file and then using the Project Deployment tool to
import the stored procedures. While in the process of importing the
stored procedures the project deployment tool dies while trying to
import a parameter that is 7000k.
Does anyone know of another way to import the stored procedures into
DB2?
- 6
- fast way to clear a stored collectionHi,
I am using the java collections interface to the transactional data
store with a btree access method.
When i have thousands of entries, calling StoredCollection.clear()
takes a long time (~1msec per entry).
If i have single process/thread access to this StoredCollection, is
there a faster way to clear() it?
Or should i rework my app so that instead of
StoredCollection.clear() i delete and reopen the underlying Db?
thanks for any tips,
-m
- 7
- DB2 equivalent for Oracle's PMON?Greetings!
Imagine 2 hosts: host A runs Oracle 10g , host B runs IBM DB2 v9. I
have to write a shell script (bask/Korn...) that checks if a database
instance is up and running and does a bunch of other stuff.
For instance, I can do something like this on host A (the host for the
Oracle 10g database):
export ORACLE_SID=<instance name>
check_db=`ps -ef|grep ${ORACLE_SID}|grep pmon|wc -l`;
checkdb_retval=`expr $check_db` ...
if [ $checkdb_retval -lt 1 ]
then
echo "Database not running!"
exit 1
fi
This works like a charm with Oracle. However, DB2 is different: I
tried the following snippet of code on host B but to no avail:
export DB2=db2inst1
export DBNAME=<database name>
check_db=`ps -ef|grep ${DB2}|grep ${DBNAME}|wc -l`;
checkdb_retval=`expr $check_db`
if [ $checkdb_retval -lt 1 ]
then
echo "Database not running!"
exit 1
fi
This is not going to work : the result this code outputs is way too
verbose to tell what's what.
Is there a sure-fire way to tell in a shell script that a DB2 instance
is up and running, e.g. something similar to grep-ping for DB2's
equivalent of PMON???
Hope you can help. TIA,
Alan.
- 8
- Performance problem on Linux (resolution)Many thanks to those who took the time to help. We have found the problem:
the tablespaces created by DB2, the 4kB tablespaces, had the transfer rate
set to 46000, whereas 0.9 is the normal value. Strangely enough, these seem
to have been automatically assigned initially when DB2 was installed. This
was giving the optimizer incorrect information on how to optimize the
queries correctly. The timerons now needed for table scan SQLs are now
almost identical on Linux and Windows and we have another happy customer.
Regards
Rudolf Bargholz
"Rudolf Bargholz" <email***@***.com> schrieb im Newsbeitrag
news:email***@***.com...
> Hi,
>
> I have a ralatively simple SQL:
>
> select FK from TABLE where upper(A) like 'B%' and upper(C) like 'D%'
>
> We have DB2 UDB v7.1 FP 12 installed on Linux and on Windows 2003
>
> On Linux using optimization level 5 as well as 9 and 0 the SQL uses
> 3'100'000'000 timerons !
> On Windows 2003 the SQL needs 26'000 timerons
>
> We have tested with SUSE Linux 9.1 as well as Redhat 7.2 , both with the
> same dramtic results. And no, the number of zeros is correct.
>
> The Table TABLE has 140'000 rows. The result set of the SQL returns 200
> rows.
>
> Any idea what could be causing this difference. The access plans are
> identical (TABLE -> TBSACAN -> RESULT) but one is acceptable, the other
not.
>
> Runstats have been executed on both tables.
>
> Another problem we have seen is, when we add an index on column A, the
> access plan becomes totally different. DB2 will perform an index scan on
> TABLE, then performs a FETCH and joins the result of the index scan with
> TABLE (!), then does a TBSCAN and then returns the RESULT. The FETCH in
this
> case takes 3'000'000'000 timerons.
>
> As I mentioned above, we tested using optimization levels 0, 5 and 9.
> Comparing the optimized SQL on Windows and Linux showed, that no
> optimization was necessary, neither on Windows, nor on Linux.
>
> Any ideas?
>
> Regards
>
> Rudolf Bargholz
>
>
- 8
- privilegesHi all
can anyone give me a link to a Reference manual
which describes all privileges on any DB object and it's meaning :-)
thnx.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
- 9
- 12
- Re:Killing an user from the userDear all,
I am having a question here. hope you guys could help. Whenever
i kill a user, i cant kill the oracle statement there, eventhough the user
had been killed. What should be the problem? Does this mean that at the
background that session still running? I encountered system slow down
problem recently and cause me to kill the user whoever using the sesssion.
Please help. Thanks
Rgrds
Feei Shun
|
| Author |
Message |
olivier.kouame
|
 Posted: 2003-10-19 2:54:45 |
Top |
database, Looking for scenario simulation tools for Oracle
Hi all,
I'm looking for a set of tools that will allow me to run a simulation
of a company database, with intelligent agents masquerading as
database users and interacting in real-time. The system would
preferably be based on the Oracle example schemas and should allow an
unlimited number of concurrent agents to be running at the same time.
I'm not looking for a load-testing tool, rather a configurable
simulator. Any ideas ?
Thanks,
Olivier Kouam?
|
| |
|
| |
|
| |
|
Index ‹ database |
- Next
- 1
- How to compile on win32Hi all,
is there a description how to install on win32?
I can't find a description anywhere.
What tools do i need?
thanks
Daniel.
- 2
- table locationHi,
I have a MS Access db MDE which is linked to some SQL tables on a server.
Now in my company we are using a certain IP address.
The same DB is given to external company to use, but they have a different
IP address, due to firewall restrictions. So in order for the external
company to use the table, they would need to create the DSN and re-link the
tables. But I do not want them to do that, because then they can direclty
access the table. On the other hand, I cannot re-link the table using their
IP address, again due to fire wall restrictions.
Now I am finding ways to change the IP address directly without using the
linked table manager. Or any other way.
Please advise.
Thanks.
- 3
- Re[2]: Global temporary table gets truncated on failed insert.Thank you very much for the skilled answer. The question is taken off,
but I eager to make some philosophic comments.
> This is working as designed for NOT LOGGED temporary tables.
> "When a rollback operation terminates a unit of work or a savepoint in
> P, and that unit of work or savepoint includes a modification to
> SESSION.T, then if NOT LOGGED was specified, the rollback includes the
> operation DELETE from SESSION.T, else the changes to T are undone."
I realize now. IMHO, the biggest trouble with IBM (from the user's
point of view) it makes things much more arduous then they could be. In
this particular case it's DB2 documentation, which could be less
intricate. The other glaring case is the way for exporting data from
DB2 to a text file.
Historically, the most successful attempt of IBM to make the simple
thing hard was "Job Control Language" for the early IBM mainfraims
(like IBM/360). People worked with JCL are wincing at the mention of :(
> Since the change was not logged there is no way to comply with
> Atomicity. So three choices remain:
> 1) drop the table (mark the table as unusable as doen for regular tables
> when NOT LOGGED operations fail)
> 2) go to the only well defined state: emtpy
> 3) leave the table in whatever state it is with an unknown amount of the
> changes done.
>
> Option 2) is deemed the most appropriate.
This decision could be contested. You could consider next arguments
against (2), but for (3).
* Rule of Least Surprise: always do the least surprising thing. (This
is also widely known as the Principle of Least Astonishment.) -- Eric
S.Raymond.
The disappearance of the innocent rows is very surprising thing.
* Since it's user responsibility for declaring "NOT LOGGED", don't
deprive him the freedom to recover the error himself, according his
current needs. If DB2 would implement (3) then user could drop table,
delete rows himself, or work further, if applicable.
This is another good principle: "Supply mechanism, not policy."
- 4
- Listing databasesSorry for the newbie question, but how do you get PostgreSQL to list
the available databases? I know how to log into a certain database, but
not list all of them. I know this must be possible because the
phppgAdmin web site demonstrates it with their trial server.
Thanks,
Doug Hall
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to email***@***.com)
- 5
- update from V8.1 Fixpak 8 to Fixpak 9We are considering to update from V8.1 Fixpak 8 to Fixpak 9.
Operating System Information:
OSName: AIX
NodeName: mdxxx01, mdxxx02, mdxxx03, mdxxx04
Version: 5
Release: 2
64 bits and DB2 code release SQL08021 with level identifier 03020106
Informational tokens are DB2 v8.1.1.80, special_13100, U800400_13100,
FixPak 8.
With DPF: 4 nodes with 16 partitions.
With 4 instances.
My concern:
--do i need to install Fixpak binary code FixPak9 on four nodes
individually?
-- do i need to update each instance on 4 nodes ?
--Where can i find documentation on update DB2 with DPF in a cluster
server?
Thank you.
- 6
- Database Links for replication between databasesHello,
Until now we do not want to use Database Links for security reasons.
But an application needs to access informations that are on two
separate DB.
As we can not use an asynchrone mecanism (night job of export/import
for example) the application provider would like to use Database
Links.
When a change occurs on the remote DB, a trigger then retrieve new
informations into a dedicated table on the local DB.
Question : is it an other way to do that ?
Regards.
- 7
- Fw: BUG #1015: Got a signal 11 while trying to create a temp tableThis is a multi-part message in MIME format.
I tried to reply to you but that doesn't work. So I try it through here..
Yours,
Aarjan
----- Original Message -----
From: aarjan langereis
To: Tom Lane
Sent: Saturday, December 20, 2003 3:17 PM
Subject: Fw: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table
Did you find time to read my email? I hope you will reply sone.
Yours,
Aarjan
----- Original Message -----
From: aarjan langereis
To: email***@***.com
Sent: Friday, December 19, 2003 9:39 AM
Subject: Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table
How do I get a "debugger backtrace" ?
Selecting all data from the tables involved, does that also include a 'count(*)', if so, they work:
stats=# select count(*) from blocks;
count
---------
3194409
(1 row)
stats=# select count(*) from hosts;
count
-------
205
(1 row)
stats=#
Yours,
Aarjan
----- Original Message -----
From: "Tom Lane" <email***@***.com>
To: <email***@***.com>
Cc: "PostgreSQL Bugs List" <email***@***.com>
Sent: Friday, December 19, 2003 4:41 AM
Subject: Re: [BUGS] BUG #1015: Got a signal 11 while trying to create a temp table
> "PostgreSQL Bugs List" <email***@***.com> writes:
> > I tried to create a temp table and got my back-end restarting because of a signal 11.
>
> Hmm. Can you get a debugger backtrace from the core dump?
>
> > It seems to me, and please correct me if I?Tm wrong, that there is a limit to the size that a join can handle.
>
> No (and certainly not on a measly 3-million-row case). This could be a
> data corruption problem, or something more subtle, but it's not that.
>
> One way of testing the data-corruption theory is to see if you can
> select all the data from the tables involved, without any join.
>
> regards, tom lane
>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1264" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I tried to reply to you but that doesn't work. So I
try it through here..</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Yours, </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Aarjan</FONT></DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=email***@***.com href="mailto:email***@***.com">aarjan
langereis</A> </DIV>
<DIV><B>To:</B> <A title=email***@***.com href="mailto:email***@***.com">Tom
Lane</A> </DIV>
<DIV><B>Sent:</B> Saturday, December 20, 2003 3:17 PM</DIV>
<DIV><B>Subject:</B> Fw: [BUGS] BUG #1015: Got a signal 11 while trying to
create a temp table</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Did you find time to read my email? I hope you will
reply sone.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Yours,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Aarjan</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=email***@***.com href="mailto:email***@***.com">aarjan
langereis</A> </DIV>
<DIV><B>To:</B> <A title=email***@***.com
href="mailto:email***@***.com">email***@***.com</A> </DIV>
<DIV><B>Sent:</B> Friday, December 19, 2003 9:39 AM</DIV>
<DIV><B>Subject:</B> Re: [BUGS] BUG #1015: Got a signal 11 while trying to
create a temp table</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3>How do I get a
"debugger backtrace" ?<BR><BR>Selecting all data from the tables involved, does
that also include a 'count(*)', if so, they work:<BR><BR>stats=# select count(*)
from blocks;<BR> count<BR>---------<BR> 3194409<BR>(1
row)<BR><BR>stats=# select count(*) from
hosts;<BR> count<BR>-------<BR> 205<BR>(1
row)<BR><BR>stats=#<BR><BR>Yours,<BR><BR>Aarjan<BR><BR>----- Original Message
----- <BR>From: "Tom Lane" <</FONT><A href="mailto:email***@***.com"><FONT
face="Times New Roman" size=3>email***@***.com</FONT></A><FONT
face="Times New Roman" size=3>><BR>To: <</FONT><A
href="mailto:email***@***.com"><FONT face="Times New Roman"
size=3>email***@***.com</FONT></A><FONT face="Times New Roman"
size=3>><BR>Cc: "PostgreSQL Bugs List" <</FONT><A
href="mailto:email***@***.com"><FONT face="Times New Roman"
size=3>email***@***.com</FONT></A><FONT face="Times New Roman"
size=3>><BR>Sent: Friday, December 19, 2003 4:41 AM<BR>Subject: Re: [BUGS]
BUG #1015: Got a signal 11 while trying to create a temp table <BR><BR><BR>>
"PostgreSQL Bugs List" <</FONT><A
href="mailto:email***@***.com"><FONT face="Times New Roman"
size=3>email***@***.com</FONT></A><FONT face="Times New Roman"
size=3>> writes:<BR>> > I tried to create a temp table and got my
back-end restarting because of a signal 11.<BR>> <BR>> Hmm. Can you
get a debugger backtrace from the core dump?<BR>> <BR>> > It seems to
me, and please correct me if I?Tm wrong, that there is a limit to the size that
a join can handle.<BR>> <BR>> No (and certainly not on a measly
3-million-row case). This could be a<BR>> data corruption problem, or
something more subtle, but it's not that.<BR>> <BR>> One way of testing
the data-corruption theory is to see if you can<BR>> select all the data from
the tables involved, without any join.<BR>> <BR>> regards, tom
lane<BR>></FONT><BR></FONT></DIV></BODY></HTML>
- 8
- Restore 8.2First time DB2 user here.
I have a backup from a unix box around 8.1.
I am trying to restore this backup on a windows box 8.2 (demo version)
I am not sure how the original backup was created but according to the
file path it looks like it is a full backup.
When using the wizards, i cannot seem to view the backup and i have got
several errors trying to use command line.
Is there a compatability issue or am i missing something. I can backup
and restore the sample databases with the wizard just fine (have not
been able to do it via command line).
Any help is much appreciated
- 9
- System catalog for trigger eventHi,
When a trigger event occurs, how does the trigger manager(called by the
Executor) set up TriggerData(tg_event in particular) information structure
before calling the trigger function to handle the event. Is the detail
available in any system table?
Googling and the documentation search does not help.
regards,
bhuvaneswaran
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
- 10
- NetBSD Sparc OKFYI, I've successfully tested on NetBSD Sparc and added it to the
supported list for 7.4.1.
--
Peter Eisentraut email***@***.com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
- 11
- now() + integer, not rounded to whole dayIs it possible to add some portion of the day to now() ? I cannot
round now() to whole days like now()::date. Hours, minutes and seconds
are also important to me. This I had in Oracle, and need to convert it
:
sysdate + 1/1440
Thanks for any suggestion.
- 12
- SQL Server CE to other databasesAs anyone had success hooking Microsoft's SQL Server 2000 CE to any
other database other than MS SQL? How about say to Oracle or Informix?
It cliams to be able to connect to any OLE DB. So far I've not
found this to be true. Anyone else??
Thanks in advance
- 13
- UPDATE FROM syntax[this didn't apparently make it thru' to pgsql-docs]
Hi, is there any documentation for Pg's UPDATE FROM (apparently
non-standard) syntax? It is mentioned briefly in \h update and not at
all in http://www.postgresql.org/docs/7.3/static/dml-update.html
or http://www.postgresql.org/docs/7.3/static/queries-table-expressions.html
(directly).
I solved my own problem but was still curious since it's non-standard if
there's a "more standard" way of updating a table from another query.
ALTER TABLE components ADD COLUMN default_body TEXT;
UPDATE components SET default_body = bb.body
FROM (SELECT b.body, cpb.component_id
FROM componentspagesbodies cpb NATURAL JOIN bodies b
WHERE cpb.page_id IS NULL) AS bb
WHERE bb.component_id = components.component_id;
(Incidently, I tried UPDATE components c SET ... c.component_id but the
parser wasn't happy with it.)
Paul
(PS and now at least one working UPDATE FROM example is online ;-)
--
Paul Makepeace ................................ http://paulm.com/ecademy
"What is it i am yapping about? Three things: location, location,
location."
-- http://paulm.com/toys/surrealism/
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
- 14
- DB2 v8.2 Installation ProblemI'm trying to install the DB2 v8.2 Universal Database Express Edition
on my standalone computer which is running Windows XP Home Edition. I
looked at the requirements in the readme file and it says that it can
run on Windows XP.
When I try to install the program I get an error message that says the
following: "DB2 Universal Database Express Edition is not supported on
this version of the operating system."
Does any know what I have to do to get around this problem and get DB2
installed on my machine?
- 15
- [pgsql-hackers-win32] Threads vs ProcessesTom Lane wrote:
"Merlin Moncure" <email***@***.com> writes:
>> All TLS variables *must* be static (or implicitly static
>> through extern, i.e. no 'auto' variables)
>I assume you mean static as in not-auto, rather than static as in
>not-global. Otherwise we have a problem here.
Yes, you are correct.
>> and their addresses can not be
>> assumed to be constant.
>Surely the addresses can be assumed constant within a thread.
Otherwise
>we have a problem here too.
Quoting from the MSDN:
The address of a thread local object is not considered constant, and any
expression involving such an address is not considered a constant
expression. In standard C, the effect of this is to forbid the use of
the address of a thread local variable as an initializer for an object
or pointer. For example, the following code will be flagged as an error
by the C compiler:
#define Thread __declspec( thread )
Thread int tls_i;
int *p = &tls_i; //This will generate an error in C.
<end>
(Note this does not apply to C++)
>> Taking addresses of TLS variables should be considered illegal,
>Sorry, no can accept that restriction.
I thought not. I believe if TLS variables are detail managed through
the win32 API, some of these problems can be avoided (after all, these
examples are for the Microsoft compiler).
Merlin
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
|
|
|
