Search results for query: *

Is it possible to restore a new database from its current position's a certain period of time(an hour,3 hours,15 minutes etc.) earlier interface? We are backing up our db once in a day on early morning time and sometimes for example when our users make a great mistake that interferes the...

Greetings. In my applications I am planning to use both connection pool (provided by the Web Service) or the connection I will construct. My database will be IBM DB2 and my question is somehow concerned but with java and DB2. When I succesfully establish a db connection How can I get the...

Recently I had met with problem with db2 fixpacks. Fixpacks 1 - 3 and 11... Now it works with no problems. Except Scheduling Tasks... Currently on my DB2 server, I have a das instance named as db2as and one second instance that holds our databases with name sahadmin. However, the schedules...

Greetings One or two tables have a (*) on F6 when we reorgchk command on our database.. We have 2 indexes on those tables and I always reorganize my table automatically with my specific index ...(with jhob scheduler).For this reason F4 value always resides on high levels , 98,99 ,100 etc...

Greetings. I installed DB2 7.1 on RS6000 server running AIX. After a successful installation we installed db2fixpack 3 and 11.. After the fixpacks, we lost the tcpip communication..The other server failed to find our server. We dropped our instance and recreated a new one named as sahadmin. We...

A couple of days ago I applied 3 fix packs into db2 7.1 working on AIX platform.The fixpacks didn't work well.db2 didn't start and we couldn't active our databases. After that we tried various processes finally we dropped our instances, recreated them. Set up our databases from back up.Also we...

Greetings . I am trying to use the DB2Connection class (that is to say COM.ibm.db2.jdbc.net or COM.ibm.db2.jdbc.net) I constructed my connection pool.Database ise IBM DB2 version 7.1 I can get my connection succesfully by lookup method. The connection returned is however is java.sql.Connection...

We have some large tables that have many records inside. These tables have reasonable foreign keys for keeping up the RI. Also the child tables that share the Id of the basic tables have many records too. We are having difficultly that is to say the performance is extremely low while attemping...

Suppose I have a table named as finance.invoice with more than one index (one of the index is primary key of course). When I reorganize my table with my index ,after checking with update statistics option DB2 updates the values and mostly clusterratio becomes 100 at that time for this index...

Greetings. I am responsible for optimizing our queries which require reasonable sources on the system. I have a problem about running runstats. According the usage of the tables I have indexes on various tables.Those indexes work very well and we are able to able significant performance...

to obtain a read (dirty read) from a table while someone is deleting row(s) from the same table? We are using java applications to make transactions but when we are trying to delete some records the other connections fall into lock-wait state (but we are %100 sure that the others want to read...

To handle the locks on my system I use the snapshot for locks command. However this command writes the result on my command center window or db2 command line processor (dos prompt). Is it possible to redirect these lock lists to a file I state? Salih Sipahi Software Engineer. City of...

Greetings everyone. I am trying to obtain a result returned by an EXE program in DOS mode. I activate the program by using appropriate java classes but couldn't manage to get the results produced by the EXE program. Is it possible to get the values? If so how? Thank you. Salih Sipahi...

Our database with version 7.2.9 running on AIX has a serious problem. I always restore a new database on the same server and do my experiments in that database. Since the records have reasonably increased, I did need of using Explain-SQL tool. According to the results; I create useful indexes...

I have DB2 database 7.1.0 with fix pack 11;that is to say I have 7.2.8 version on Windows Platform. However I have problems in my command center;I can't run my multiple queries sequentially when the queries are ended by ";".I select the use termination character ";" but this performs single...

I have Windows XP Pro in my system that has Websphere Studio Application Developer 5.0 installed. However I have a problem that haven't found a solution yet. I create a J2EE application and basically it creates 3 different modules web,ejb,application client. After that I created a simple...

I have a db2 7.1 database which is in 1254-TR code page. When I use following SQL, national language characters(Ý,ý,þ) are wrongly converted or interpreted so no result is returned. Expected result is "4,Micheal". SELECT NO,NAME FROM EMP WHERE UPPER(NAME) LIKE 'MÝ%' Data: No Name 4...

In order to run DB2 in Windows XP Professional,I downloaded fixpack 10 from IBM's web site. Everything seemed in order but the sql commands in command center window. The problem is db2 processor tries to execute the commands in such a way that one line means one command... e.g. When I type a sql...

Is it possible to modify the sql warning or error messages in db2?I always have to catch the sql message number and modify the explanation in my applications. Salih Sipahi Software Engineer. City of Istanbul Turkey s.sipahi@sahinlerholding.com.tr

We have a backup of our database in Windows platform but we couldn't manage to restore it on AIX platform. The error message was :"No match for this database with timestamp provided blah blah blah" but the current timestamp,or db name is correct. We also do have tablespaces apart from...