Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / October 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
UDB 8.1 FP7a / Error DBA 110727 Oct 2004 06:59 GMT3
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 Center27 Oct 2004 06:25 GMT3
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.627 Oct 2004 04:41 GMT2
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 110726 Oct 2004 18:52 GMT1
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 GMT2
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/db2start26 Oct 2004 14:53 GMT3
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 DEFAULT26 Oct 2004 11:40 GMT1
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 GMT3
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 state25 Oct 2004 23:57 GMT4
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 sp25 Oct 2004 15:11 GMT3
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 GMT7
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 GMT3
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 Update25 Oct 2004 09:01 GMT8
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 Column25 Oct 2004 07:39 GMT1
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 CLIST25 Oct 2004 04:21 GMT3
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
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 September, 2004
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.