DB2

Filesystem configuration on HP UX for DB2
On Apr 21, 11:09 pm, Ian <ianb...(a)mobileaudio.com> wrote: On 4/21/10 3:42 AM, FM wrote: Good morning My question is about Filesystem configuration on HP UX for DB2. Is there any known "Best Practice" o special configuration for HP Filesystem (fstab) for running DB2 Server 9.5 on it? ... 23 Apr 2010 20:38

SYSPROC.ADMIN_COPY_SCHEMA
Does SYSPROC.ADMIN_COPY_SCHEMA (used to change schema names) work in a DPF environment? Are the files exported and reloaded with DEL format (not IXF)? ... 28 Apr 2010 02:50

Shutdown all instances
for i in `ps -ef |grep db2sysc |awk '{ print $1 }'|sort -u`; do su - $i -c db2stop force; done :-) On 21.4.2010 11:15, db2 dba wrote: Never mind, on AIX "grep"ping for 'db2sysc' process shows the active instances. If anybody thinks this is not right or has a alternate (better) way please post. ... 23 Apr 2010 17:24

DB2 9.7 - UDF modifying data - Is this possible?
Hi All, Is it possible in DB2 to create a UDF which performs an insert into a table and retunrs an integer? From reading the DB2 doco this doesn't seem to be possible and trying with a simple sample proved my assumption. I understand that this can be achieved by using a procedure rather than a function but the ... 23 Apr 2010 20:39

DB2 UDB Security Best Practices documentation
I can find lots of items that deal with how to change the settings for DB2 datbases as "best practices" documents. What I haven't seen is anything like a becst-practices checklist style doument for DB2. There are lots for Sybase and MS SQLServer, but can't see to find any for DB2. Can someone point me where t... 20 Apr 2010 15:42

knowing if an NLI is active or has occurred recently
Hi all - Running AIX 6, UDB 9.1.4. Other than referring to the db2inst1.nfy log is there anyway to know if a table has been created with 'not logged initially'? I need something that I can query to determine the NLI status. Thanks, Bruce ... 23 Apr 2010 20:39

knowing if an NLI is active or has occurred recently
On Apr 20, 1:33 pm, "Mark A" <no...(a)nowhere.com> wrote: "Bruce" <bwmille...(a)gmail.com> wrote in message news:ae7155e6-6ce7-49b0-9ccb-f4a5f441748e(a)22g2000vbg.googlegroups.com... Hi all - Running AIX 6, UDB 9.1.4. Other than referring to the db2inst1.nfy log is there anyway to know i... 20 Apr 2010 15:42

DB2 UDB V9.5 Lock wait event capability?
In the UDB V9.7 Fixpack 1 the Lock wait event is included. Is this performance/bottlebeck assesment capability retrofitted in DB2 9.5 also and if so, in which FixPack? Bernard Dhooghe ... 3 May 2010 08:43

DB2 join operator
Hi, I have a query that runs fine with SQL Server but gives me an exception with DB2 Part of the query using join operator and the ON clause contains subquery. The exception I am getting is the following: An ON clause associated with a JOIN operator or in a MERGE statement is not valid for one of the foll... 28 Apr 2010 00:37

Help on an UPDATE query
I am on DB2 V9.5 on AIX. The following is a query I want to use for an update. It works fine except when I add the "Fetch first 1000 rows" db2 "UPDATE tab1 SET (col1, col2, col3) = (1, 'Y', 'Y') WHERE col1 <> 1 AND name IN ( SELECT name FROM tab2 WHERE colA IN (SELECT name FROM tab3 WHERE colB I... 20 Apr 2010 15:42