The supported way of calling statements like 'BEGIN ATOMIC END', 'CREATE PROCEDURE', 'CREATE TRIGGER' from CLP is to define an alternate termination character other than the default termination character(;)
Ref : http://pic.dhe.ibm.com/infocenter/db...%72%6f%63%65%6...
Shashank1984
Last Activity: Jul 29 '13, 12:20 PM
Joined: Jul 29 '07
Location:
-
db2diag.log captures deadlock @ DIAGLEVEL 4 as the message is of type "INFO"
here is the test case :
On term1:
db2 "create db sample"
db2 "connect to sample"
db2 "create table testtab1 (col1 int)"
db2 "create table testtab2 (col1 int)"
db2 +c "lock table testtab1 in exclusive mode"
On term2:
db2 "connect to...Leave a comment:
-
manjuns,
It's not allowed in DB2.
The data type of the value to be assigned to the column, parameter, SQL variable, or transition variable by the SQL statement is incompatible with the declared data type of the assignment target. Both must be:
* Numeric
* Character
* Graphic
* Dates or character
* Times or character
* Timestamps or character
* Datalinks
...Leave a comment:
-
manjuns,
Here is your testcase....
C:\Documents and Settings\Admini strator>db2 -tvf a.txt
create table A(a1 varchar(10) not null primary key)
DB20000I The SQL command completed successfully.
create table B(b1 varchar(10), a1 varchar(10) references A (a1) on delete cascade)
DB20000I The SQL command completed successfully.
insert into A(A1) values('a1')
DB20000I The SQL...Leave a comment:
-
Folks,
Here is the list of some SQL30081N TCP/IP communication protocol errors and recommended action plans associated with them.
http://www-01.ibm.com/support/docvie...id=swg21164785
Cheers !
Thanks,
Shashank Kharche, IBM.
DB2 for Linux, Unix & Windows -Information Management Software...Leave a comment:
-
I have seen type of error ages before but looking at the limited information you provided I cannot confirm. You should give details of the Environment !
- Exact OS Level/ db2level
- rpm -qa |grep db2
- I would also like to see contents of file /opt/IBM/db2/V8.1/instance/db2iutil
from line number 380 to 390. You can paste these 10 lines here.
Thanks,
Shashank Kharche, IBM.
DB2 for Linux,...Leave a comment:
-
DB2 database systems support some backup and restore operations between different operating systems and hardware platforms.
The supported platforms for DB2 backup and restore operations can be grouped into one of three families:
* Big-endian Linux and UNIX
* Little-endian Linux and UNIX
* Windows
Platform - Endianness
=============== ===
AIX® big endian...Leave a comment:
-
No worries mate, cheers !!!
Shashank Kharche, IBM.
DB2 for Linux, Unix & Windows -Information Management SoftwareLeave a comment:
-
The only way to accomplish what you are doing is to unload the tables, drop the tables, drop the tablespaces, recreate the tablespaces, recreate the tables and import data. You will not be able to convert from SMS to DMS with redirected restore.
Thanks,
Shashank Kharche, IBM.
DB2 for Linux, Unix & Windows -Information Management SoftwareLeave a comment:
-
Gday mate,
First of all...lemme give you different scenarios that affect the SYSCAT.TRIGGERS table's 'VALID' column in viper.
Case #1: If you are adding a column to a table AFTER the trigger was created on the table, this will not update the dependency relationship between the table and the trigger, there is NO dependency between the new column with trigger. So, when the column is dropped, 'trigger is operated' (X) is false....Leave a comment:
-
Hello folks,
The root cause of this problem is when configuring fixpack failed and running config_EC, eClient gets updateType "base" instead of "fixpack".
eClient can only acquire the parameter updateType from the IDR file (ECMInstallData V8.xml) which is controled by install.
So, this is a problem mainly in install.
To work around this problem, the customer can undeploy...Leave a comment:
-
Mate, I can see you asked same que to DB2 level-1 support in AU. Just wondering if you have got your required info or not yet :-) -
G'day Mate,
Since Concurrent I/O implicitly invokes Direct I/O, all the performance considerations for Direct I/O hold for Concurrent I/O as well. Thus, applications that benefit from filesystem read-ahead, or have a high filesystem buffer cache hit rate, would probably see their performance deteriorate with Concurrent I/O, just as it would with Direct I/O. On AIX 5.2.10, Concurrent I/O is the preferred method since it is not subject...Leave a comment:
-
Mate,
Here is the Explanation and User Response for this error.
Make sure you know this and go through the response.
C:\Documents and Settings\Admini strator>db2 ? sql1336n
SQL1336N The remote host "<hostname> " was not found.
Explanation:
The system cannot resolve the address of the remote host.
Possible causes are:
o An incorrect hostname...Leave a comment:
-
So your basically trying to Improve insert performance.
You might have to study/look how intra_parallel works.
Moreover, when SQL statements use INSERT to place new information in a table, an INSERT search algorithm first searches the Free Space Control Records (FSCRs) to find a page with enough space. However, even when the FSCR indicates a page has enough free space, the space may not be usable because it is reserved...Leave a comment:
-
You can have look over this technote.
SQL30081N TCPIP communication errors
IBM - SQL30081N TCPIP communication errors
Thanks,
Shashank Kharche
IBM, DB2 for Linux, Unix & Windows -Information Management SoftwareLeave a comment:
-
depending on available info it will be like hunting in dark forest....
I would say...
- make sure "classpath" is set properly and contain the appropriate Webtools jar files
- you might have to paste the db2diag.log and tomcat log entries "during" the occurrence of this error.
- some more background info of the prb..(db2/os levels...when you say "While accessing DB2 web tools"...what exactly...Leave a comment:
-
G'day mate,
1) Make sure you have DB2 Connect product installed.
(All I can see from above db2licm is just DB2 Express-C)
2) There is a known defect : (see if your hitting this)
IZ08501: Connection to host/iseries using the IBM Data Server Driver for ODBC and CLI on Windows results in SQL8002N
(http://www-01.ibm.com/support/docview.wss?uid =swg1IZ08501)
Are you using drivers on Win?
...Leave a comment:
-
On the client side, either local or remote applications, or both, are linked with the DB2 client library. Local clients communicate using shared memory and semaphores; remote clients use a protocol such as Named Pipes (NPIPE), or TCP⁄IP.
On the server side, activity is controlled by engine dispatchable units (EDUs). In all figures in this section, EDUs are shown as circles or groups of circles. EDUs are implemented as threads...Leave a comment:
-
Superkuper,
Regarding the new db2 agents...i.e.db 2stmm and db2taskd..
New DB2 agents have been introduced in DB2 Version 9.1: db2stmm and db2taskd. The db2stmm agent is part of the new self-tuning memory feature added in DB2 Version 9.1. The db2taskd agent is an internal daemon that distributes background database tasks. These new agents remain connected to the database at all times and are not active if the database is activated...Leave a comment:
No activity results to display
Leave a comment: