vbace2
Last Activity: Oct 20 '10, 11:40 AM
Joined: Apr 18 '07
Location:
-
What is the best way to make a copy of production db using DB2v9 Windows?
I need to set up a nightly process that will refresh a database from another database. We have some complicated reports that users are trying to run against our production database that is causing performance issues for the application users. The reports do not need to have real time data. Data as of last night is perfect. We have some scripts that will drop and recreate a database, and then do a redirected restore of the database from a backup.... -
Windows Permissions Help
Hope someone can help me here...
I have a Windows 2003 box running Apache/2.2.4 (Win32).
I have a Windows NT server that I need to access files on.
When I try to view/create files on the NT server using a webpage, I get permission denied errors. I am currently using PHP, but I am sure that I would receive the same errors in other languages.
Does anyone know what user I need to give permissions... -
Issue accessing MS Access database on another server
I have searched this forum, and the web, and I have not been able to find a solution to my issue. I may not have used the right search information to find the answer, but I found a lot of issues close to mine, but nothing has helped.
We are running Apache/2.2.4 (Win32) PHP/5.2.3.
I am trying to use the odbc_connect to connect to an MS Access database that is on another server. I have tried to use both a system DSN,... -
DOS Scripts and/or Task Center Help
DB2 9.1 fixpak 2 on Windows
I am trying to set up a task in the task center that will run on a daily basis to check for an "issue". To find this "issue", I run a select statement that brings back a count. If the count is something other than zero, then the "issue" exists.
Is there a way to run a select statement in the task center, and from the results, mark it as either successful (count... -
HADR and Federation
Using DB2 v9.1 fixpak 2 (WSE with HADR feature) on Windows 2003 Servers
We are trying to set up HADR for two production databases. The two primary databases reside on two different servers. We would like to put the two standby databases on the same server. One of the databases (we will call it NICKNM) has tables federated from the other database (we will call it OTHER). I was able to set up HADR for these two databases so that... -
Control Center not listing Database
DB2 9.1 fixpak 2 on Windows
For some reason, I can't see a database in the control center. I can't see it under All Database, nor can I see it under All Systems. I am using control center on the machine where the database is. If I so a db2 list database directory, the database shows up. I have refreshed the control center, I have restarted the control center, and I have restarted the database. Nothing seems to work.
... -
HADR and container paths
DB2 v9.1 (fixpak 2) on Windows
I am currently trying to move our primary database to a faster server. I am also trying to set it up on HADR (where the standby will also be on a new, faster server). We are a 24/7 shop, and I was hoping to avoid an outage. I was hoping to set up HADR from the current server to the new server. Once that was done, I was hoping to switch roles, turn off HADR, and then turn it back on again with the... -
When looking at the link, it looks like this refers to using Java to open the cursor. I am trying this from a DB2 internal stored procedure.... -
Can you use "with hold" with a prepare statement?
Hi. I am using DB2 v9.1 fixpack 2.
I was wondering if there is a way to use the with hold option when using the prepare statement. Or, is there another way that I can do what I need to?
I have a procedure that dynamically creates and drops a table. So, I am using a prepare statement to get all the values from one of the columns. I am then calling a procedure for each returned row. However, the procedure that I am...
No activity results to display
Leave a comment: