Search results for query: *

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

Thanks for your help. I was omitting the restore step.

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...

Very Thanks! The problem was the missing of SVCENAME parameter. I also learned that SVNAME parameter resides on the server level,not in the instance level. Come to Istanbul and I will offer you Raki and Sish Kebap! :) Salih Sipahi Software Engineer. City of Istanbul Turkey...

juliane, Thanks for your very reasonable reply. I managed to set the DB2COMM parameter. but for the other parameter I could not set the other variables. I found the correct information from the services file as you suggested and from our other AIX server. Those are variable I failed to set...

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...

My mistake.. The correct syntax should be: String Np1_dob = (request.getParameter("p1_dob"))==null?"null":"'request.getParameter("p1_dob")'"; String UpdSql = "update db2admin.T_CUS_NAP set " ; UpdSql = UpdSql + "(CUS_ORG, CUS_PTNR1_DOB, CUS_PTNR1_SPS_NM, CUS_PTNR1_SPS_DOB) =...

String Np1_dob = (request.getParameter("p1_dob"))==null?"null":'request.getParameter("p1_dob")'; String UpdSql = "update db2admin.T_CUS_NAP set " ; UpdSql = UpdSql + "(CUS_ORG, CUS_PTNR1_DOB, CUS_PTNR1_SPS_NM, CUS_PTNR1_SPS_DOB) = ('"; UpdSql = UpdSql + Ndname +...