Questions tagged [db2]
25 questions
0
votes
2 answers
Windows DB2 9.7 FP8 - The request failed because private virtual memory could not be allocated. SQLSTATE=57011
I have a Windows DB2 9.7 FP8 server running on Windows 2003 x86 that for some reason every time I launch Center Administrator or the CLI and try to connect to a database, I get the error "[IBM][CLI Driver] SQL1219N The request failed because private…
user500741
- 101
0
votes
1 answer
DB2 : How to resolve "SQL0206N "INVOICEDATE" is not valid in the context where it is used.SQLSTATE=42703" error
In linux i connected to DB2 and trying to grab oldest invoice.
while using this below query it shows an error SQL0206N "INVOICEDATE" is not valid in the context where it is used.SQLSTATE=42703
db2 "select min(INVOICEDATE) from RHA2";
How can I…
sai prudhvi
- 41
0
votes
1 answer
DB2 v10 database size growth monitoring range
I need to know my IBM DB2 database growth range. e.g. database size growth from last 1 month or last 3 months or Last 6 months ..
Please assist or anyone can provide query or else advice accordingly.
0
votes
1 answer
DSMTOP failed during start with insuficient privileges for SYSDBA user
recently we upgraded our DB2 v10.5.8 to v11.1.4. We sucessfully upgraded all instances (check via db2 get dbm cfg) and then run command db2updv111 -d dbname to upgrade databases. Unfortunately it seems, that it was not fully successful. When I try…
Ondřej Žižka
- 15
0
votes
1 answer
How to find details of disk usage in DB2 on Cloud
We have provisioned a flex DB2 on CLoud PaaS service with 250GB disk space.
How do we know how much of that is used for tablespaces, activelogs, tempspace, installation directory and so on?
Since this is a managed service and has no host login, if…
amar
- 1