database >>db2diag error - "oper system services sqloWaitInterrupt Probe:10 "

db2diag error - "oper system services sqloWaitInterrupt Probe:10 "

Index ‹ database

Previous
- 2
  - db2 conf. on HP UX problemHP UX 11i, db2 v8.2
    
    kernel parameters of HPUX such as shmmax had been changed to MEM*0.9, about
    3.6g.
    
    when I create a partitioned db(4 partitions)on the server, warning raised
    saying that not enough memory for bufferpool use. when I lower the user of
    bufferpool to only 8000(8k page),error vanished.
    
    4G memory in total, but it seems that I can only use very little of them.
    the HP UX is 64bit, db2 instance is 32 bits.
    
    can you help me on the very problem? thank you~~
- 4
  - 7.3.5 release (was: Re: SELECT with row>32k hangs over SSL-Connection)Tom Lane wrote:
    > Bruno Wolff III <email***@***.com> writes:
    >> I think that a 7.3.5 release should be done a bit after 7.4 is released,
    >> but my opinion doesn't count for much.
    >
    > Yeah, I think we have accumulated enough changes in the 7.3 branch to
    > justify a 7.3.5, but I'm not sure when we'll get around to it.
    
    On 10/03/2003 Bruce was the only one responding to my question if the
    namespace fix I had for PL/Tcl should be backpatched into 7.3.5. He
    claimed that we'll probably not release any 7.3.X any more and we
    dropped the issue.
    
    Guess the question is open again then.
    
    Jan
    
    --
    #======================================================================#
    # It's easier to get forgiveness for being wrong than for being right. #
    # Let's break this rule - forgive me. #
    #================================================== email***@***.com #
    
    ---------------------------(end of broadcast)---------------------------
    TIP 6: Have you searched our list archives?
    
    http://archives.postgresql.org
- 4
  - Update 5 zh_TW files for 8.0Am Montag, 1. November 2004 11:09 schrieb Zhenbang Wei:
    > Eliminated fuzzy messages.
    
    Installed.
    
    --
    Peter Eisentraut
    http://developer.postgresql.org/~petere/
    
    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to email***@***.com)
- 5
  - CLOB data is getting truncated on SELECTWhen I am SELECT'ing a CLOB column from command prompt, the output is
    getting truncated after a certail limit (8 K ??)
    How do I get the full data out of a CLOB column? Are there any string
    manipuration functions for CLOB fields to read it in multiple chunks ?
    
    Thanks in advance.
- 5
  - common UPDATE syntax for SqlServer and OracleThe UPDATE table FROM syntax is not supported by Oracle.
    
    I am looking for a syntax that is understood by both Oracle and SqlServer.
    
    Example:
    
    Table1:
    
    id name city city_id
    1 john newyork null
    2 peter london null
    3 hans newyork null
    
    Table2:
    
    id city
    23 london
    24 paris
    25 newyork
    
    UPDATE table1
    SET city_id = table2.id
    FROM table1, table2
    WHERE table1.city = Table2.city
    
    If possible I do not want to have two different statements for Oracle and
    SqlServer
    
    Please do not tell me that these tables are not normalized, it's just an
    example!
    
    Thanks for any hints.
    
    Jan van Veldhuizen
- 6
  - SOS - how to uninstall DB2 Express 8.1. on Windows Server 2000I need to uninstall DB2 Express on a W2K Server as the
    evaluation period has expired to reclaim a fair chunk of
    disk space.
    The program was not in the list of the Windows
    Add/Remove Programs in the Control Panel,
    (but is for Windows XP) nor was there an Uninstall
    program as part of DB2 menu tree.
    
    So, I decided to try uninstall it manually by deleting
    folders and files and registry entries.
    
    It didn't work. Most of the files and folders could not be
    deleted. Got messages like ' so-and-so' is in use/shared'.
    
    Can anyone suggest how I can get it off the W2K Server? OR
    point me to a more appropriate forum OR
    how to get free assistance from IBM (as they should have
    provided an uninstaller in the first place).
    
    Best regards
    Ken Resander
- 7
  - Using c_del to delete some duplicates but not all - possible?
    When you use a cursor on a key with multiple data items, is it
    possible to use c_del to remove the data items one at a time?
    
    If not, is there another method of doing this?
    
    Why I care: I've got a set of message queues set up in a
    database server, where the key identifies the engine which reads the
    message, and the messages are all stored as duplicates under
    that key. Upon receiving the right command the server reads
    back all the messages stored at that time using a cursor (it
    counts using c_count then loops over that many NEXT_DUP records).
    It should deleteeach messages from the DB immediately after sending.
    I've been getting "Invalid argument" errors trying to code this, but
    I'm sure the arguments are valid because 1) they're so simple and
    2) the c_count and c_get calls just prior to this work fine. So,
    I'm thinking there must be some deeper logical problem I've missed.
    
    The obvious (to me, anyway) alternative way to do this would be
    to lock the key while reading back, then delete all the records
    at the end. The problem there is that there could be quite a
    lot of messages to read out, and there is a very good chance more
    will be coming in at the same time, so this would create a serious
    bottle-neck and I'd probably have to spend a few hours on coding
    other bits to reduce it (ie setting up the client with an in-memory
    queue rather than processing the messages directly).
    
    Implementing each queue as a separate QUEUE database seems an
    unattractive option because the number of them is large and dynamic.
    (At a rough guess, maybe a couple hundred queues with queues being
    added and closed at a rate of a few per hour and no way in advance
    to know useful IDs for each).
    
    Any advice will be much appreciated, thanks.
    
    --
    Steve Bougerolle <email***@***.com>
    http://www.imperialrealms.com http://www.imperialrealms.net
    http://www.bougerolle.net
    http://www.sebgitech.com
- 7
  - implosion follow up, 7.4.5The new thread on 7.4.5 losing committed transactions popped up just as
    I discovered something that was at least unexpected to me.
    
    In doing the cleanup from my pg_resetxlogs from today's earlier fun, I
    found some missing rows and some duplicate row versions showing up in my
    restore. All of this was within a 90 second period, which makes sense to
    me.
    
    What doesn't make sense to me is that I'm missing 19 records in one
    table that were committed 3 hours before my crash. There were no errors
    before the crash, there were no errors in the dump after the
    pg_resetxlog. I have application logs that confirm these records were
    present; not only do I have logs showing they were saved, but logs from
    later processes manipulating these records.
    
    I'm running 7.4.5 on RHAS 3 x86-64 on 4x244 32GB system. It's NFS
    attached. Derogatory remarks about NFS welcome, but you're preaching to
    the choir. :)
    
    The only thing unusual thing I noticed today was abominable performance
    for several hours before the crash (Load=30, iowait=95%). This machine
    has been running for weeks with excellent performance - generally 4
    times faster than my dual Xeon 2.4Ghz, 12GB RAM, 6x36GB U320 RAID 1+0
    systems.
    
    Typically in my benchmarking sessions and application runs, I rarely saw
    any read activity - it appeared that everything was pulled straight out
    of the disk buffer cache. Today, NFS was choked with reads, despite
    having 10GB of RAM free (!). Nothing has changed on this machine in at
    least 4 weeks.
    
    Any ideas are appreciated. While I'm sure the crash is hardware/config
    related, the missing 19 records from something committed 3 hours earlier
    is confusing. :)
    
    As always, any insight is appreciated. We are very committed to
    PostgreSQL after booting a large Oracle installation out 16 months ago.
    
    thanks!
    
    ---------------------------(end of broadcast)---------------------------
    TIP 6: Have you searched our list archives?
    
    http://archives.postgresql.org
- 7
  - LOAD message fileFrom the message file generated by LOAD utility:
    
    SQL3119W The field value in row "F1-14" and column "14" cannot be converted
    to an INTEGER value. A null was loaded.
    
    how do I identify the line in the load file that caused the exception above?
    
    Thanks
    -Eugene
- 7
  - Possible bug?Hello,
    
    I saw this 'bug' reported in the Firebird SourceForge website for the
    Firebird 1.0 server. They confirmed it as a bug! I tried it in PostgreSQL
    7.2 (I know its an old release but I do not have a newer version installed,
    and in any case I am only using the server for reserach purposes).
    PostgreSQL returns no rows for either of the queries. Of course this is the
    case since the attributes F1 and F2 of Table T1 are of type Char whereas
    the select query is making the test with an integer value. Is this the
    intended behaviour?
    
    Firebird returns 0 rows for the first query and 1 row (values 3,3) for the
    second query. I also tried it in Oracle 8.0.5 which returns 1 row for each
    of the two queries. Therefore I have different results being returned from
    all three servers.
    
    Reproducible script:
    
    CREATE TABLE T1 (F1 CHAR(4), F2 CHAR(4));
    
    CREATE INDEX T1_F1 ON T1 (F1);
    
    INSERT INTO T1 (F1, F2) VALUES ('001', '001');
    INSERT INTO T1 (F1, F2) VALUES ('002', '002');
    INSERT INTO T1 (F1, F2) VALUES ('003', '003');
    INSERT INTO T1 (F1, F2) VALUES ('004', '004');
    
    SELECT * FROM T1 WHERE F1 = 3;
    
    F1 F2
    ---- ----
    
    SELECT * FROM T1 WHERE F2 = 3;
    
    F1 F2
    ---- ----
    
    Best regards,
    
    Ilir
    
    Ilir Gashi
    PhD Student
    Centre for Software Reliability
    City University
    Northampton Square, London EC1V 0HB
    Tel: +44 20 7040 0273
    Fax: +44 20 7040 8585
    email: email***@***.com
    website: http://www.csr.city.ac.uk/csr_city/staff/gashi/
    ____________________________________________
    
    ---------------------------(end of broadcast)---------------------------
    TIP 6: Have you searched our list archives?
    
    http://archives.postgresql.org
- 8
  - FKs and deadlocksHello,
    
    As the amount of simultaneous users of my database grows (25 users
    sometimes, PGSQL 7.4.5), deadlocks are unfortunately more and more
    frequent. I guess this is due to the FKs problem with Postgresql.
    
    I have tried to correct that by adding a "SET CONSTRAINTS ALL DEFERRED"
    in every trigger and function, hoping it would solve my problem. Maybe
    it helped, but it did not solve anything.
    
    I don't know if anyone has a better idea, but I would like to try taking
    away some FKs in my schema. My problem is that I really don't know which
    one to delete. There are over 40 tables. Are there rules to do that? Or
    maybe can I simply wait on the next deadlock, and try understanding who
    got locked by who? OK, but how can I do that?
    
    Thanks for your help!
    
    Philippe
    
    Note: I have read about a patch for FK's, is that something that can
    really be used in production?
    
    ---------------------------(end of broadcast)---------------------------
    TIP 4: Don't 'kill -9' the postmaster
- 9
  - Connecting for DB2 UDB on NTUsing the DB2 R/T client on the client machine, set up a local alias for the remote database. Define a DSN for this alias on the client machine. When you make ODBC calls to this DSN, ODBC and the R/T client work together to get the remote data and give it to your application as if the data was kept locally.
    
    N. Shamsundar
    University of Houston
    
    Yogesh wrote:
    >
    > Friends,
    >
    > I am absolutely new to the world of DB2. I am trying some samples.
    > (Accessing DB2 Databases using ODBC / OLE DB libraries). I have
    > insatalled DB2 UDB v8.1 on Win 2000 Prof. and an trying to connect to
    > the databases from another box on the network.. I have installed DB2
    > Run-Time Clients, v8.1 on the client w/s.
    >
    > The Database created on the server is ODBC aware...
    >
    > When I try to configure the ODBC drivers on the client w/s, the
    > drivers are not able to connect / discover the UDB server. I guess I
    > am missing something like making the UDB server "known" to the
    > client..
    >
    > any help to get me going is highly appreciated.
    >
    > Thanks
    > Yankee.
- 14
  - UDF call to C wrapper for PCRE library fails - SQL0444N, Reason code: "5", SQLSTATE=42724Hi all,
    
    I'm trying to complete the samples from the excellent 2003
    developerWorks article "Bringing the Power of Regular Expression
    Matching to SQL" by Knut Stolze:
    
    http://tinyurl.com/3bhrnn
    
    I've managed to compile and link the C code from "Listing 5", the
    regexpSimple() wrapper (see link). The build options are pretty much
    the result of trial-and-error using the samples in
    /home/db2inst1/sqllib/samples/c/. Any advice on how to successfully
    call the C wrapper from a DB2 UDF is appreciated.
    
    # Environment
    DB2/LINUX 9.1.0
    gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-3)
    
    # Flags
    $ EXTRA_LFLAG="-Wl,-rpath,$DB2PATH/lib"
    $ DB2PATH=/home/db2inst1/sqllib
    $ DB2V9LIBS=/opt/ibm/db2/V9.1
    $ SHARED_LIB_NAME=regexUdf
    
    # Compile the program.
    $ gcc $EXTRA_C_FLAGS -fpic -I$DB2PATH/include -I$DB2V9LIBS/include -c
    utilapi.c -D_REENTRANT
    $ gcc $EXTRA_C_FLAGS -fpic -I$DB2PATH/include -I$DB2V9LIBS/include -c
    regex1.c -D_REENTRANT
    
    # Link the program and create a shared library
    $ gcc $EXTRA_C_FLAGS -shared -o $SHARED_LIB_NAME regex1.o utilapi.o
    $EXTRA_LFLAG -L$DB2PATH/lib -ldb2 -lpthread
    
    # Copy and chown shared library
    $ cp $SHARED_LIB_NAME $DB2PATH/function
    $ chown db2inst1: $DB2PATH/function/$SHARED_LIB_NAME
    $ ls -l /home/db2inst1/sqllib/function/regexUdf
    -rwxr-xr-x 1 db2inst1 db2grp1 10624 Feb 20 10:16 /home/db2inst1/
    sqllib/function/regexUdf
    
    However, calling this function from DB2 fails with "SQL0444N":
    
    $ sudo su - db2inst1
    $ db2 "connect to sample user db2inst1"
    Enter current password for db2inst1:
    
    Database Connection Information
    
    Database server = DB2/LINUX 9.1.0
    SQL authorization ID = DB2INST1
    Local database alias = SAMPLE
    
    $ db2 -t -f /home/db2inst1/test/db2/regex/regex1.sql
    DB20000I The SQL command completed successfully.
    
    $ db2 "select FIRSTNME, LASTNAME from employee where regex1('\w+',
    FIRSTNME) = 1"
    
    FIRSTNME LASTNAME
    ------------ ---------------
    SQL0444N Routine "REGEX1" (specific name "REGEXSIMPLE") is
    implemented with
    code in library or path ".../sqllib/function/regexUdf", function
    "regexpSimple" which cannot be accessed. Reason code: "5".
    SQLSTATE=42724
    
    $ cat /home/db2inst1/test/db2/regex/regex1.sql
    CREATE FUNCTION regex1(pattern VARCHAR(2048), string CLOB(10M))
    RETURNS INTEGER
    SPECIFIC regexSimple
    EXTERNAL NAME 'regexUdf!regexpSimple'
    LANGUAGE C
    PARAMETER STYLE DB2SQL
    DETERMINISTIC
    NOT FENCED
    RETURNS NULL ON NULL INPUT
    NO SQL
    NO EXTERNAL ACTION
    ALLOW PARALLEL;
    
    $ cat /home/db2inst1/test/db2/regex/regex1.c
    /*
    http://www-128.ibm.com/developerworks/db2/library/techarticle/0301stolze/0301stolze.html
    
    listing5
    
    A small chunk of C code, which implements the UDF entry point. This
    entry point is called by DB2 during the query execution for each
    row to be matched against the pattern. Listing 5 is an example what
    this code could look like. For the description of the pcre_*
    function and macros, refer to the documentation of the PCRE
    library. For compiling the C code and building the shared
    libraries, refer to the DB2 Application Development Guide.
    
    */
    
    #include <pcre/pcre.h>
    #include <sqludf.h>
    
    void regexpSimple(
    // input parameters
    SQLUDF_VARCHAR *pattern, SQLUDF_CLOB *str,
    // output
    SQLUDF_INTEGER *match,
    // null indicators
    SQLUDF_NULLIND *pattern_ind, SQLUDF_NULLIND *str_ind,
    SQLUDF_NULLIND *match_ind,
    SQLUDF_TRAIL_ARGS)
    {
    pcre *re = NULL;
    const char *error = NULL;
    int errOffset = 0;
    int rc = 0;
    
    // we assume successful return
    *match_ind = 0;
    
    // compile the pattern to its internal representation
    re = pcre_compile(pattern, 0 /* default options */, &error,
    &errOffset, NULL);
    if (re == NULL) {
    snprintf(SQLUDF_MSGTX, 70, "Regexp compilation failed at "
    "offset %d: %s\n", errOffset, error);
    strcpy(SQLUDF_STATE, "38900");
    (*pcre_free)(re);
    return;
    }
    
    // match the string againts the pattern
    rc = pcre_exec(re, NULL, str->data, str->length, 0,
    0 /* default options */, NULL, 0);
    switch (rc) {
    case PCRE_ERROR_NOMATCH:
    *match = 0;
    break;
    case PCRE_ERROR_BADOPTION:
    snprintf(SQLUDF_MSGTX, 70, "An unrecognized bit was set in the
    "
    "options argument");
    strcpy(SQLUDF_STATE, "38901");
    break;
    case PCRE_ERROR_NOMEMORY:
    snprintf(SQLUDF_MSGTX, 70, "Not enough memory available.");
    strcpy(SQLUDF_STATE, "38902");
    break;
    default:
    if (rc < 0) {
    snprintf(SQLUDF_MSGTX, 70, "A regexp match error "
    "occured: %d", rc);
    strcpy(SQLUDF_STATE, "38903");
    }
    else {
    *match = 1;
    }
    break;
    }
    
    // cleanup
    (*pcre_free)(re);
    return;
    }
- 14
  - timestamp with time zone question...i have a table with a 'timstamp with time zone' column.
    
    when i insert into it:
    
    '18 Nov 2004 00:00:00 PST'
    
    ...it looks like:
    
    2004-11-18 03:00:00-05
    
    ...once stored in the database.
    
    0 o'clock vs. 3 o'clock.
    
    is it storing in the time zone of the actual server or something? not
    sure where my db server actually, physically is.
    
    if so, does that imply that i can translate these stored dates to any
    target time zone of my choosing when selecting the date from the db?
    
    - philip
    
    ---------------------------(end of broadcast)---------------------------
    TIP 7: don't forget to increase your free space map settings
- 14
  - CPU skyrockets during contention
    Oracle 10.1.0.3.0
    Whenever we see row-level contention, or even today when a table loc
    caused contention for incoming DML, we see a huge spike in CPU activit
    (and then our web applications which don't even use these tables star
    sending timout msgs to our admin).
    
    Why does Oracle penalize the entire system for contention between
    users, and is this happening because of some configuration we'v
    unknowingly set?
    
    Thanks,
    Chuc

Author

Message

Kiran

Posted: 2005-1-3 16:34:35

Top

database, db2diag error - "oper system services sqloWaitInterrupt Probe:10 " Check out of the paths given for the tablespaces exists. try to stop
all other external porgrams running and try running the SP. Is your
rows inserted correctly ?.
Try giving absolute path ..if you have not given relative path in
creating table spaces.

Thiru

Posted: 2005-1-4 21:21:00

Top

database >> db2diag error - "oper system services sqloWaitInterrupt Probe:10 " I have an exclusive control over that system and nobody is using that..
Then i haven't created the tablespace and so i don't know what path
they have given(relative or absolute).

I don't understand this sentence.. Where to give the absolute path??
"Try giving absolute path ..if you have not given relative path in
creating table spaces."
Bare me.. I am newbie to DB2...

Thanks.
Thiru,
WantedToBeDBA.

Kiran

Posted: 2005-1-4 21:47:00

Top

database >> db2diag error - "oper system services sqloWaitInterrupt Probe:10 " Thiru ,
I guess you should create a temporary tablespace if want to use
temporary table ..and if you have given a DMS then you may need to
give the container name also .
I am also a newbie buddy ..lets look for other replies..

Kiran Nair

dotyet

Posted: 2005-1-4 22:43:00

Top

database >> db2diag error - "oper system services sqloWaitInterrupt Probe:10 " for temporary tablespace as an SMS:
db2 "create user temporary tablespace tempspc1 pagesize xK managed by
system using ('<absolute path to the directory which will contain
temporary tablespace>') bufferpool xKbp"

for temporary tablespace as a DMS:
db2 "create user temporary tablespace tempspc1 pagesize xK managed by
database using (FILE '<absolute path to the file which will contain
temporary tablespace>' size_value|K|M|G) bufferpool xKbp"

however, I don't think 55000 are that many records to take 22 hours.
don't know, but maybe, taking a snapshot of the application | dynamic
sql may help.

regards,
dotyet

Index ‹ database

Next
- 1
  - Error: SQL0971I'm noticing a problem with a table on AS400. Basically I'm running a
    select * and I'm getting back
    
    Error: SQL0971 - Constraint DIVAPPPRDIV in check pending state.
    (State:S1000, Native Code: FFFFFC35)
    
    Any thoughts?
- 2
  - Error In Oracle InstallationDear Group Hi:
    Hope to see you in good health.
    I want to Install Oracle 9i on Red Hat Linux 9, I follow each and
    every step in the Tutorials located at
    "http://www.puschitz.com/InstallingOracle9i.shtml#OracleInstallationProblemsTipsAndHints".
    Now when I try to run the Installer I got following error:
    
    ********************************************************************************
    HERE STARTS THE ERROR:
    ********************************************************************************
    Unexpected Signal : 4 occurred at PC=0x80664a7
    Function name=(N/A)
    Library=(N/A)
    
    NOTE: We are unable to locate the function name symbol for the error
    just occurred. Please refer to release documentation for
    possible
    reason and solutions.
    
    Current Java thread:
    
    Dynamic libraries:
    08048000-0804c000 r-xp 00000000 16:07 797469
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/bin/i386/native_threads/java
    0804c000-0804d000 rw-p 00003000 16:07 797469
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/bin/i386/native_threads/java
    40000000-40012000 r-xp 00000000 16:07 989700 /lib/ld-2.3.2.so
    40012000-40013000 rw-p 00011000 16:07 989700 /lib/ld-2.3.2.so
    40013000-40024000 r-xp 00000000 16:07 911046
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/libverify.so
    40024000-40026000 rw-p 00010000 16:07 911046
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/libverify.so
    40026000-4002c000 r--s 00000000 16:07 194922
    /usr/lib/gconv/gconv-modules.cache
    4002f000-4003d000 r-xp 00000000 16:07 989729
    /lib/libpthread-0.10.so
    4003d000-40040000 rw-p 0000e000 16:07 989729
    /lib/libpthread-0.10.so
    40080000-40089000 r-xp 00000000 16:07 765031
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/native_threads/libhpi.so
    40089000-4008a000 rw-p 00008000 16:07 765031
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/native_threads/libhpi.so
    4008a000-4027a000 r-xp 00000000 16:07 358490
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/client/libjvm.so
    4027a000-40378000 rw-p 001ef000 16:07 358490
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/client/libjvm.so
    4038f000-40391000 r-xp 00000000 16:07 989711 /lib/libdl-2.3.2.so
    40391000-40392000 rw-p 00001000 16:07 989711 /lib/libdl-2.3.2.so
    40392000-404b1000 r-xp 00000000 16:07 989707 /lib/libc-2.3.2.so
    404b1000-404b5000 rw-p 0011e000 16:07 989707 /lib/libc-2.3.2.so
    404b7000-404c7000 r-xp 00000000 16:07 989715 /lib/libnsl-2.3.2.so
    404c7000-404c8000 rw-p 00010000 16:07 989715 /lib/libnsl-2.3.2.so
    404cb000-404eb000 r-xp 00000000 16:07 989713 /lib/libm-2.3.2.so
    404eb000-404ec000 rw-p 00020000 16:07 989713 /lib/libm-2.3.2.so
    404ec000-40520000 r-xp 00000000 16:07 422143
    /usr/lib/libstdc++-2-libc6.1-1-2.9.0.so
    40520000-4052c000 rw-p 00033000 16:07 422143
    /usr/lib/libstdc++-2-libc6.1-1-2.9.0.so
    4052e000-4054f000 r-xp 00000000 16:07 911047
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/libjava.so
    4054f000-40551000 rw-p 00020000 16:07 911047
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/libjava.so
    40552000-40566000 r-xp 00000000 16:07 911048
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/libzip.so
    40566000-40569000 rw-p 00013000 16:07 911048
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i386/libzip.so
    40569000-4129a000 r--s 00000000 16:07 116082
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/rt.jar
    412c7000-4156c000 r--s 00000000 16:07 116083
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/i18n.jar
    4156c000-41582000 r--s 00000000 16:07 116070
    /tmp/OraInstall2004-04-17_02-55-37PM/jre/lib/sunrsasign.jar
    4867f000-4887f000 r--p 00000000 16:07 519195
    /usr/lib/locale/locale-archive
    4889a000-488a4000 r-xp 00000000 16:07 989721
    /lib/libnss_files-2.3.2.so
    488a4000-488a5000 rw-p 00009000 16:07 989721
    /lib/libnss_files-2.3.2.so
    
    Local Time = Sat Apr 17 14:55:52 2004
    Elapsed Time = 1
    #
    # HotSpot Virtual Machine Error : 4
    # Error ID : 4F530E43505002C4
    # Please report this error at
    # http://java.sun.com/cgi-bin/bugreport.cgi
    #
    # Java VM: Java HotSpot(TM) Client VM (1.3.1_02-b02 mixed mode)
    #
    ******************************************************************************
    HERE ENDS THE ERROR
    ******************************************************************************
    
    I searched Internet and other resources but couldnt find any thing
    like that, so can you people help me in any way, your help will be
    greatly appreciated.
    Take care of ure self.
    Azhar
- 3
  - Unable to install Oracle 9i on IBM R51 notebookConfiguration matches all of the other notebooks we use that have Oracle
    installed and running without any problems with the exception of centrino
    processor and some preinstalled IBM services that have been disabled.
    
    Any help is welcome.
- 4
  - PostgreSQL is much faster than MySQL, only when...Hello,
    I have changed DB from MySQL to PostgreSQL. When I have run my
    application on PostgreSQL it was disaster - it was much slower than
    MySQL...
    
    I have tried to change PG configuration file etc.. no luck. After many
    long days of thinking what is wrong I have made several tests with
    "EXPLAIN" statement, and to my amusement there was many SeqScan - MySQL
    didn't show that things. I have made some changes in PG db structure
    (new indexes etc) and then I have made another test: PostgreSQL time -
    10ms, MySQL time - 1 sec. I've tried to change the structure in MySQL
    but it didn't change the results.
    
    So my advise for all users which think that MySQL is faster than PG -
    re-check your DB structure, check all your querys using EXPLAIN... maybe
    new indexes should be added etc.
    
    Regards,
    Marek
    
    ---------------------------(end of broadcast)---------------------------
    TIP 3: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to email***@***.com so that your
    message can get through to the mailing list cleanly
- 5
  - When was Get Routine and Put Routine introducedHi all,
    
    can anyone tell me with which version of DB2 UDB Get Routine and Put Routine
    was introduced to move stored procedures from a test to a production system?
    
    Regards
    
    Rudolf Bargholz
- 6
  - Trigger example in "C"Hi,
    
    where can I find trigger example writen in "C" ?
    
    I have many made in pgSQL, but I have performance problems and I will
    try to rewrit in "C".
    
    regards,
    ivan.
    
    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to email***@***.com)
- 7
  - ANN: eValid FT-150 Top Page Download Time SurveyThis is a multi-part message in MIME format.
- 8
  - Database on Linux/ext3 unrecoverable after power downI am quite new to BerkeleyDB --- working my way through the
    documentation in order to be able to use BerkeleyDB in our project.
    
    In one of our tests, we lost the whole data base after a power
    shutdown --- this is exactly what we want to avoid in our application.
    Please help me by pointing out how I have to use BerkeleyDB correctly
    to avoid data loss.
    
    Here are the details:
    
    Debian Linux; ext3 filesys block size: 4096.
    BerkeleyDB.pm 0.26; BerkeleyDB 4.3, block size: 4096.
    
    A simple perl script (see below) opens a transactional data base and
    adds entries and checks random entries for correctness.
    
    The script and the data base perfectly survive killing the script (I
    tried this more than 1000 times). But when I switch down the power and
    restart the computer, I get the following symptoms:
    
    Startup:
    kjournald starting. Commit interval 5 seconds
    EXT3-fs: hda1: orphan cleanup on readonly fs
    EXT3-fs: hda1: 3 orphan inodes deleted
    EXT3-fs: recovery complete.
    
    This indicates that some write operation had not been completed
    properly and that the ext3 journal recovered the file system.
    
    I started the script again (hoping that the database survived the
    power-down), but it did not open the environment.
    
    Now, running db4.3_recover -c in the data base directory, I get the
    following messages:
    
    db_recover: Log sequence error: page LSN 20 4378733; previous LSN 20
    4379147
    db_recover: Recovery function for LSN 20 4378733 failed on forward pass
    db_recover: PANIC: Invalid argument
    db_recover: PANIC: fatal region error detected; run recovery
    db_recover: DB_ENV->open: DB_RUNRECOVERY: Fatal error, run database
    recovery
    
    The error log file contains the same messages.
    
    The documentation states about errors
    Log sequence error: page LSN # ######; previous LSN ## ######.:
    
    A database update was made outside of a transaction. Check that your
    application passes a transaction handle to all opens and updates of
    transactionally protected databases. This error leaves the environment
    unrecoverable, and the databases must be dumped and reloaded.
    
    Please point me to the right place how I can ensure that our data bases
    survive power down.
    
    Here is the script:
    
    use BerkeleyDB ;
    
    # open data base environment
    my $Env = BerkeleyDB::Env->new (
    -Home => '/home/www/111/F',
    -Flags => DB_INIT_MPOOL | DB_INIT_LOCK |
    DB_INIT_LOG | DB_INIT_TXN | DB_CREATE | DB_RECOVER,
    -ErrFile => '/home/www/111/F/db_error.log',
    ) or die "Cannot open enviroment: $!\n";
    
    # open a data base within an transaction
    my $txn0 = $Env->txn_begin(); my %db;
    my $db=tie %db, 'BerkeleyDB::Btree',
    -Env => $Env,
    -Filename => "db.db",
    -Flags => DB_CREATE,
    -Txn => $txn0 ,
    or die "Cannot open 'authoritys.db': $!\n";
    
    # Commit the opening of the database
    $txn0->txn_commit();
    
    # Print information about the data base
    my $stat=$db->db_stat; print "$_=$stat->{$_}\n" for sort keys %$stat;
    
    # read and write the data base within transactions
    my $r;
    while(1) { # inifinite loop -- stop by signal or power down
    
    # Create a transaction object, associate it with the database
    my $txn1 = $Env->txn_begin();
    $db->Txn($txn1);
    
    # keep an index where to write in the data base
    my $w=1+($db{"w"}||0); $db{"w"}=$w;
    # write some data
    $db{(reverse $w)x20}=$w x 100;
    
    # get random, previously written index
    $r=1+int(rand($w-1));
    # check the data for integrity
    unless ( $db{(reverse $r)x20} eq ($r x 100)) {
    print "read error: $r\n";
    }
    
    # commit the transaction and start all over again.
    $txn1->txn_commit () ;
    }
- 9
  - can't create database cause access failure in db2spcatHello!
    
    I set up DB2 Personal Edition on Fedora C4 Linux. During the
    Installprocess everything looks fine. But if I try to create a Database
    DB2 says: "Routine "db2spcat" (specific name SQL050805133333590) is
    implemented with code in library or path "\db2spcat", function
    "db2spcat" which cannot be accessed. Reason code:"4". SQLState=42724"
    
    I restarted DAS as dasusr1 and restartet DB2 as db2inst1 - but no luck!
    If I try to set up the Sample Databse via First Steps Tool, the Tool
    hang up (sleep mode at taskmanager).
    
    Is there someone can help me?
    
    Thanks
    
    Christian Meier
- 10
  - Mac Sql*Plus export with UNIX linefeedHi all,
    
    I've got a set of scripts that I run in Sql*Plus, running in the Classic
    environment on Mac OSX. The scripts use the spool feature to export
    large volumes of data from an Oracle database table to a file, and the
    data is subsequently being imported into OpenBase using the (very fast)
    ImportFile stored procedure.
    
    The only flaw is, the files created by Sql*Plus have a Mac line feed
    (hex 0D) and the OpenBase stored procedure only works with a UNIX line
    feed (hex 0A). I have tried a number of different SET parameters in
    Sql*Plus, and I've also tried a number of different NLS_LANG options,
    but I can't get Sql*Plus to export with UNIX line feeds.
    
    I can change the line feed in BBEdit or TextWrangler, but this involves
    opening the file, which doesn't work well when the file gets VERY big.
    
    Any ideas on how to export with UNIX line feeds?
    
    Any better way to change the line feeds on an existing document?
    
    Thanks,
    
    Jim
- 11
  - How to return a record set from function.On Wednesday 27 August 2003 08:18, Kumar wrote:
    > Dear Friends,
    >
    > I am newbie to Postgres. I am running 7.3.4 on Linux 7.3. I am using
    > Pgadmin tool. I need to return the table rows via record set.
    >
    > Create table t1 (c1 int, c2 varchar, c3 varchar);
    >
    > Create or Replace function sel_t1 () returns setof records as '
    > select c1, c2, c3 from t1;
    > ' Language SQL;
    >
    > It was fine and created a function. while i execute it as
    >
    > select sel_t1;
    >
    > I got the following error.
    >
    > ERROR: Cannot display a value of type RECORD
    
    You probably want to return "setof t1" and then do:
    
    SELECT * FROM sel_t1();
    
    --
    Richard Huxton
    Archonet Ltd
    
    ---------------------------(end of broadcast)---------------------------
    TIP 8: explain analyze is your friend
- 12
  - Cannot allocate additional FCM - v8.2 DPFI am getting this:
    RETCODE : ZRC=0x8B59000D=-1957101555=SQLKF_NOMEM_BUFFER_HEAP
    "No memory available in 'FCMBP Heap'"
    DIA8300C A memory heap error has occurred.
    
    and this
    FUNCTION: DB2 UDB, fast comm manager, sqlkfResrcFreeMemCheck, probe:100
    MESSAGE : Shared mem. set is not big enough for more FCM buffers. Cur
    size: 297598976, Max size: 320307200, Needed size: 437059584
    
    When trying to increase my FCM_NUM_BUFFERS from 65536 to 98304. I am
    increasing because I originally got this when executing an import:
    FUNCTION: DB2 UDB, fast comm manager, sqlkf_alloc_buffer, probe:55
    MESSAGE : Ran out low/med priority buffers. Total=65536; Num in
    freelist=13095; med thres=13107; hi thres=6553
    
    Anybody have any clues why I cannot allocate more memory to FCM.
    
    I am on AIX 5.3, DB2 v8.2 FP9 with DPF.
    (2) P575's, 8 partitions each, 32GB Memory per p575
    
    I am not paging - so looks like I have available memory on the box.
    
    Any help would be appreciated.
    
    Thanks, John
- 13
  - == PostgreSQL Weekly News - November 22nd 2004 ==== PostgreSQL Weekly News - November 22nd 2004 ==
    
    After a month of development, this week saw the release of PostgreSQL 8.0.0
    Beta 5. It should be available from your local mirror and the bittorrent
    site, for full information check out the official release announcement
    (http://archives.postgresql.org/pgsql-announce/2004-11/msg00005.php). Those
    testing the native windows and Cygwin releases should also look for new
    builds as well.
    
    Given our late date of the beta testing process, we had a pretty good number
    of fixes put in over the last week. The win32 problems with signals and
    sockets have been resolved. A couple of backend crash scenarios were fixed;
    one involving creating tables with more than 65K columns, and one when
    processing select queries with more than 65K target list entries. The default
    size of the local lock hash table was reduced, speeding up subtransaction
    entry and exit. Stat reporting has been changed to occur at transaction
    commit time to avoid confusing autovacuum when an updating transaction runs
    for a long time. Some new options were added to pg_autovacuum to support
    setting the cost-based-vacuum parameters differently from their default
    values. Updates to pg_database are now forced out to disk immediately after
    ALTER DATABASE, avoiding scenarios where an incoming backend finds no live
    copies of a database's row.
    
    Plpgsql's handeling of SPI execution during an exception block was changed to
    continue using the old connection rather than starting a new SPI connection.
    This fixing some memory mangement issues that had been recently reported.
    Several fixes also went in for plperl including cleaning up some compiler
    warnings, consolidating some duplicate code, improve the checking of the type
    of data returned from perl, adjusting of the safety restrictions, and
    modifying error handling within functions.
    
    == PostgreSQL Product News ==
    
    Daffodil Software Open Sources synchronization tool at SourceForge.net
    http://www.daffodildb.com/daffodil-opensources-news.html
    
    LatinSecurity AwakE v3.1
    http://www.linuxelectrons.com/article.php/20041120141845306
    
    FmPro Migrator 2.57 Enterprise Edition
    http://www.prweb.com/releases/2004/11/prwebxml179639.php
    
    ANN: DBManager 3.0
    http://archives.postgresql.org/pgsql-general/2004-11/msg00769.php
    
    == PostgreSQL In The News ==
    
    Introducing Slony
    http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
    
    SDForum: Open source becoming first option
    http://www.computerworld.com.au/index.php/id;1747676449;fp;16;fpid;0
    
    PostgreSQL vs. MySQL - a subjective view (blog)
    http://www.gnegg.ch/archives/prosgresql_vs_mysql_a_subjective_view.html
    
    == PostgreSQL Events ==
    
    PostgreSQL Seminar: Ankura, Turkey: December 1
    Devrim Gunduz will present a seminar about upcoming features of PostgreSQL 8.0
    http://seminer.linux.org.tr
    
    == PostgreSQL Weekly News - November 22nd 2004 ==
    On the Web:
    http://www.postgresql.org
    
    ---------------------------(end of broadcast)---------------------------
    TIP 8: explain analyze is your friend
- 14
  - Crash when calling a pl/pgsql function with no row to pass as an argument
    ========================================================================
    ====
    POSTGRESQL BUG REPORT TEMPLATE
    ========================================================================
    ====
    
    Your name : Chris Campbell
    Your email address : email***@***.com
    
    System Configuration
    ---------------------
    Architecture (example: Intel Pentium) : PowerPC G3
    
    Operating System (example: Linux 2.4.18) : Mac OS X 10.3.2 (Darwin
    7.2.0)
    
    PostgreSQL version (example: PostgreSQL-7.4.1): PostgreSQL-7.4.1
    
    Compiler used (example: gcc 2.95.2) : gcc 3.3 20030304
    
    Please enter a FULL description of your problem:
    ------------------------------------------------
    
    postmaster crashes if it tries to call a pl/plgsql function that
    requires a table row as an argument, and there is no row produced in
    the query that can be passed in. There is currently an assertion in the
    code to guard against this case, but it's not an error case, so it
    needs to be handled more gracefully than crashing. :)
    
    Please describe a way to repeat the problem. Please try to provide a
    concise reproducible example, if at all possible:
    ----------------------------------------------------------------------
    
    In order to encounter the situation described above, you have to
    execute a query that calls a pl/pgsql function expecting a table row as
    an argument, but have the query produce no row that can be passed in.
    For example, doing a left join between a patient and dentist table
    where there is no dentist row for a corresponding patient row. And then
    call a pl/pgsql function, passing in the nonexistent dentist row.
    
    CREATE TABLE patient (
    patient_id INTEGER,
    first_name TEXT,
    last_name TEXT,
    dentist_id INTEGER
    );
    
    CREATE TABLE dentist (
    dentist_id INTEGER,
    first_name TEXT,
    last_name TEXT
    );
    
    CREATE OR REPLACE FUNCTION full_name(dentist) RETURNS text AS '
    DECLARE
    d ALIAS FOR $1;
    BEGIN
    RETURN d.first_name || '' '' || d.last_name;
    END;
    ' LANGUAGE 'plpgsql';
    
    -- Note: John Smith has no dentist
    INSERT INTO patient (patient_id, first_name, last_name) VALUES (1,
    'John', 'Smith');
    
    -- Get a list of patient IDs and dentist names
    SELECT p.patient_id, full_name(d) AS dentist_name
    FROM patient p
    LEFT JOIN dentist d ON (p.dentist_id = d.dentist_id);
    
    If you know how this problem might be fixed, list the solution below:
    ---------------------------------------------------------------------
    
    Change the assertion protecting against this case in
    src/pl/plpgsql/src/pl_exec.c to an if statement, so that the row
    argument is only copied into the function's arguments if the row
    actually exists. Otherwise, a row with no columns is passed in to the
    function, which gets NULLs when it tries to access any of the row's
    columns. I think this is correct behavior -- if there was no row, then
    there should be no values passed into the function.
    
    See the attached file pl_exec.c.patch (diffed against postgresql 7.4.1).
    
    Thanks!
    
    - Chris
    
    ---------------------------(end of broadcast)---------------------------
    TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to email***@***.com)
- 15
  - APPLICATION DEVELOPER-DB2I NEED 2 CONTRACTORS WITH AT LEAST 8 YEARS OF MAINFRAME
    PROGRAMMING EXPERIENCE AND UTILITIES. THIS INCLUDES, COBOL OS390, VSAM,
    DB2, JCL, PROCS, TS0, ENDEAVOR, FILEAID, EXPEDITOR, AND SAS. EXPERIENCE
    MAINTAINING AND UPDATING LEGACY PROGRAMS. EXCELLENT ANALYTICAL AND
    PROBLEM SOLVING SKILLS. KNOWLEDGE OF INFO MAN A PLUS. EXCELLENT WORKING
    KNOWLEDGE OF HEALTHCARE INSURANCE. EXCELLENT ORAL AND WRITTEN
    COMMUNICATION SKILLS. ABILITY TO WORK WELL WITH OTHERS IN PAST PACE
    ENVIRONMENT. ABILITY TO MEET PROJECT DEADLINES ON TIME AND WITHIN BUDGET.
    KNOWLEDGE OF CLIENT-SERVER APPLICATIONS AND WEB APPLICATIONS A PLUS.
    WORKING KNOWLEDGE OF UML.
    
    Required Skills ( Years) : COBOL(3), DB2(3), JCL,SAS,TSO(3),
    EXPEDITOR(3), FILEAID(3), ENDEAVOR(3)
    
    Start Date:21-JUN-04
    End Date:31-DEC-04
    Work Location:BROOKLYN, NY, NEW YORK CITY, USA
    Rate $40/hr.
    
    Please submit resume to email***@***.com You will get a reply !