| Thread | Last Post | Replies |
|
| UDB 8.1 FP7a / Error DBA 1107 | 27 Oct 2004 06:59 GMT | 3 |
Hallo allerseits, habe die UDB 8.1 mit dem Fixpack 7a versehen. Will man nun aus dem ControlCenter die Leistungsparameter mit dem Wizard neu berechnen lassen, so wird beim fertigstellen dieser Schritte die Fehlermeldung DBA 1107
|
| Deleted Backups on Control Center | 27 Oct 2004 06:25 GMT | 3 |
When doing a restore using control center, i see the backups that are no longer existing. That i physically deleted. Is there a specific way to deleted the backups? Should i manually mark the backups as expired in the history file?
|
| Backup DB2 MVS OS/390 7.2 and Restore to DB2 UDB AIX 8.1.6 | 27 Oct 2004 04:41 GMT | 2 |
I just want to confirm that it is not possible to perform a backup from DB2 MVS OS/390 and then restore it to DB2 UDB AIX 8.1.6. Everything I am seeing says you can not do a cross platform restore of this type. I just want to confirm again. Thanks.
|
| UDB 8.1 FP7a / Error DBA 1107 | 26 Oct 2004 18:52 GMT | 1 |
the UDB provided 8,1 with the fixed luggage 7a. If one wants to let the achievement parameters with the Wizard compute now from the control center again, then with to finish these steps the error message DBA is caused 1107. The possibilities of error represented
|
| Health monitor causing issues! | 26 Oct 2004 16:14 GMT | 2 |
Hellos again, I seem to be having a weird issue. Whenever DB2 Health monitor seems to run, all connections to the database seem to just lock up. For example: (and this seems consistent) In list applications, DB2Hmon
|
| db2dari processes remaning after db2stop/db2start | 26 Oct 2004 14:53 GMT | 3 |
db27.2 fp7 on AIX5.2 I just bounced the database (as a specific db2dari process had reached user memory limit), and some (orpahned) db2dari processes are still there.
|
| Can I ALTER a column to have a DEFAULT | 26 Oct 2004 11:40 GMT | 1 |
We have decided to make certain columns have a DEFAULT value? Can I ALTER to do this or do I have to rebuild all the tabled with such elements?
|
| Is it bad to see "High water mark for database heap = 4291373408" when the server has 4G memory? | 26 Oct 2004 03:28 GMT | 3 |
When I did db2batch to benchmark a query, it performance details came back with this reading ... "High water mark for database heap = 4291373408" Does this mean it would have caused memory thrashing at the server?
|
| rollforwaring a database which is NOT is rollforwarding state | 25 Oct 2004 23:57 GMT | 4 |
All of this is still a test envinonment, but has to go on production.... I restore a database a database the follwing way db2 restore db <database> from <directory. taken at <timestamp> replace existing
|
| get time in a sp | 25 Oct 2004 15:11 GMT | 3 |
i'm trying to get the time with a store procedure but i don't nkow how to do it. can someone help me?? tanks in advance.
|
| V8.2 - SQL/PL Continue handlers not working? | 25 Oct 2004 13:50 GMT | 7 |
Having just upgraded one of our servers to V8.2, the CONTINUE HANDLERs in Stored procedures seem to be behaving differently? i.e Instead of continuing at the next statement (as they did before on V8.1)
|
| How do i connect UNIX TO UNIX Machines??? | 25 Oct 2004 10:37 GMT | 3 |
Hi friends, i have a unix machine PC1 where a database is running ( IBM DB2 V8.1 ) . Then i have another machine PC2 i installed there also ( IBM DB2 V8.1 ). On PC2 i installed unixODBC. To connect to the database over ODBC on unix i did
|
| Statement Problem Update | 25 Oct 2004 09:01 GMT | 8 |
Hi @ll, have some trouble on DB2 V8.1. When i make a statement like this... Update DocObj set pid=0 where pid is null.
|
| Length of Data in CLOB Column | 25 Oct 2004 07:39 GMT | 1 |
Is there an easy way to get the length of data stored in a CLOB column, in bytes? Unfortunately, "SELECT LENGTH(clob_column) FROM table" doesn't work. Thanks,
|
| Need to connect to DB2 via a CLIST | 25 Oct 2004 04:21 GMT | 3 |
I wrote a DB2 stored procedure in COBOL, and now I need to prepare a CLIST in order to call it. This CLIST would be for people who want to use the stored procedure outside of COBOL or Pl/I. I am not familiar with CLISTS and don't know where to begin. My stored proc has a long
|