You could try scheduling a script.
One way is do it writing a program which would run every day to delete the 'expired' rows.
Try doing in that in DB2 Script Center.
Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
The importance of your log files are answered on my question with subject "Putting The Clock Back"
Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
As an addition..I have a question for my log files. When I decide to delete the logs older than a period of time e.g 3 months what steps should I do?
Is there any database configuration for that?
Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
Hmm.There must be more sophisticated methods for that but..
If I were you I'd try this..
I would create an empty tablespace managed by system and would note its initial size.
Then create a table of 2 columns one is a fixed type (integer,character etc) and a column of varchar(6) with cursor or a...
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...
DB2 distinguishes that.. That is the Application ID. But we can't distinguish that from Websphere Enviroment - I mean from the programme side.That is the problem [peace] :)))))...
Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
There could be many situations for that. For example you run an ERP project that has various modules with many users.
One of the user calls a report but that report contructs a very severe SQL and allocates many resources. That allocation reduces the performance of the current transaction of...
Yes. That is the tricky question. Once I tried to use DB2 Connection but couldn't find a clue there.
Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
When you get a connection from DB2, DB2 gives that connection an Application ID. I need that "Application ID" in my java applications.My modules do establish a jdbc connection successfully but what I need is; I want to know "which connection" goes to "which one of my applications".That is 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...
In fact yes. But I don't have a Varchar column used as an index. But my index has a 4 columns. That may cause a miscalculation you stated.
We have version 7. With fix pack 11..( 7.2.9 )
I hoped it miscalculated I just wanted to be sure If I made something missing.
Ties: Thanks for your help...
Ties. Thanks for your response. I had read the same document before and performed these steps below:
My table is Konf.Envanter_Hareket
It has 2 indexes one is the primary key as usual and here named as PK_ENV_HAREKET
The other one is KONF.IND1_FIRMA1 which is ESSENTIAL FOR US..
The...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.