DB2
in [SQL]
|
String comparison in DB2 Hi All, I created a table with only one char(1) column and inserted values from 'A' to 'Z'. After that I am executing "select * from tablename where colname between '0' and 'z'. It gives me all the data except 'Z' (capital Z). As I am not getting 'Z', it makes me wonder how does DB2 compare the strings (convert... 19 Jun 2008 23:58
DO YOU WANT SAP IDES for your Desktop Check your requirement from the following list of Software SAP IDES for Your Personal Practice at Home. I. SAP ECC 6.0 SR2 12DVDs + Screen shot Installation Guide II. SAP ECC 5.0 IDES 7 DVDs + Screen shot Installation Guide III. SAP 4.7IDES 3 DVDs + Screen shot Installat... 17 Jul 2008 03:26
Getting memory size for an application Hello, I am running DB2 V8.2 on AIX. I am looking for a way to get the memory size of a specific db2 agent. I have found the db2mtrk tool that gives me a list of all the applications and heap sizes. Also there is "DB2 Snapshot for Application" but I am looking for a way to capture the data for C code without havi... 19 Jun 2008 16:48
Getting rid of nuls Is there a way to use either the REPLACE() or TRANSLATE() function to change ascii nul characters (chr(0)) in a given table/column to a different character? I've tried what I think should work, but both functions seem to get confused when they encounter the nul in the column. Here's what I've tried: CREATE TAB... 19 Jun 2008 16:48
Cannot redirect restore into a different database name. On May 13, 11:09 am, Larry <la...(a)nospam.net> wrote: Does the target database already exist? It is unique on the target system? Larry E. sharon.zhang...(a)gmail.com wrote: Hi, I'm using the following command to redirect restore from source database AAA into target database BBB: ... 19 Jun 2008 01:14
Catalog Service - User interrupt detected Good Morning folks, Our DB2 servers currently complains about the below error, "User interrupt detected". I've been researching for quite long and I haven't got any good explanation nor solution on this. Could someone give me a hint please? Thanks in advance Simon Here is the error message in DB2 ins... 19 Jun 2008 12:40
BACKUP & RUNSTATS running simultaneously Hi Am using DB2 UDB ESE on AIX platform. I used to take a full/ incremental online backup regularly. This process used to go on since years. But recently, whenever am trying to take the same, am receiving the 911 error msg. I have understood that the 911 errors are due to the locks held by RUNSTATS appln. on the ... 28 Jun 2008 03:30
Is it possible to "enable" auto-rollback functionality while dead-lock occurred on DB2/400? Hi, DB2/400 seems not able to auto-rollback one of transactions while dead- lock occurred. I called the procecure QSYS.CREATE_SQL_SAMPLE for creating sample database, and used ISQL (STRSQL) & Navigator (Run SQL Scripts) to evaluate it: Session A (Isolation Level = CS): 1) insert into sampledb/staff values... 22 Jun 2008 04:03
CPU usage in DPF on Windows during massive parallel single row inserts Hello, all. DB2 v9.5.1 ESE, Windows 2003 Server 64-bit, 4 CPU (8 cores) each, DPF environment. There are 2 DPF instances on the same set of 5 computers. One computer holds coordinator partitions and other 4 hold partitioned tables (2 logical nodes per computer). Application: DataStage v8 running some (say 32... 19 Jun 2008 03:26
db2 load using v9.1 client into a v8.1 fixpak 16 database Hi, Iam unable to load using a v9.1 Fixpak 0 client into a v8.1 Fixpak 16 database. I get the following error: SQL3015N An SQL error "-206" occurred during processing. The message file gives a few more details: SQL0206N "PROTECTIONGRANULARITY" is not valid in the context where it is used. SQLSTATE=427... 19 Jun 2008 01:14 |