Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Hattusas
-
row retention period
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 -
Manage DB2 logfiles. Please advice.
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 -
Putting The Clock Back
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 -
Putting The Clock Back
Thanks for your help. I was omitting the restore step. -
Varchar
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... -
Putting The Clock Back
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... -
Java and DB2
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 -
Java and DB2
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... -
Java and DB2
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 -
Java and DB2
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... -
Java and DB2
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... -
DB2 FIXPACK ON AIX ... Problem Part 2
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... -
* on F6
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... -
* on F6
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... -
* on F6
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...
