Questions tagged [db2]
The db2 tag has no usage guidance.
25
questions
0
votes
0
answers
19
views
how to open .ter file saved from toad for db2
I have saved diagram from toad and it is extention is .ter, can anyone tell me hot to be able to open this file in another windows machine
- 231
0
votes
1
answer
514
views
Ansible: Switching to su user and when running tivoli db2 command, gives command not found
when manually ran db2 command on the server works. But when executing using ansible which switches to the user but fails to run the db2 command. I am stuck on this issue for the whole day. Any ...
0
votes
1
answer
102
views
DB2 syntax error
I am using the below SQL statement to calculate the size of application group data table.
SELECT A.TABLE_NAME FROM ARSSEG A, ARSAG B WHERE A.AGID=B.AGID AND B.NAME='<application group name>' ...
- 41
0
votes
1
answer
10k
views
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 "...
- 41
0
votes
1
answer
124
views
DB2 9.7 task center do not work in SUSE 11 sp4 - DBA1176N
I've install DB2 9.7 enterprise edition on suse 11 sp4, the problem is that when i want to see "task center" it show's bellow error:
DBA1176N The Control Center failed to automatically catalog the ...
0
votes
0
answers
118
views
db2 create failing with SQL1762N
db2 V10.5 RedHat Linux RHEL7. Installed without error.
db2 create db AMW907 on /home/mis/amw907 fails with
SQL1762N Unable to connect to database because there is not enough space to allocate active ...
- 1
0
votes
1
answer
695
views
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
3
answers
307
views
db2 crash with db2 force application command
We have installed db2 on Linux Power machine.
DB2 level is 11.1.4.4.
I have kill single session with "db2 force application (agent_id)", and it crashed database.
We have observed that this is 3rd ...
- 1
0
votes
1
answer
157
views
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 ...
- 15
1
vote
0
answers
281
views
MS Access Error: Invalid field definition 'CON474' in definition of index or relationship
Looking for some help with a MS Access problem.
I am creating a bunch of linked tables between Access and our AS400 (iSeries) system. I have some OBDC DSN's set up and can access the system without ...
- 11
0
votes
1
answer
227
views
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 ...
- 1
-1
votes
3
answers
6k
views
How can I find a number in a string in DB2 SQL [closed]
I need to find a number in a string in DB2 SQL,
and I have the position of the first number.
Can anybody help me please?
- 39
1
vote
2
answers
1k
views
How to I establish CODEUNIT32 (CHAR SET = "UTF-32" in DDL?
I am trying to model a request for a column that will be VARCHAR(120), but will actually store 480 bytes.
The length of 480 is established as VARCHAR (120) = 120 x 4 = 480 bytes. This is due to ...
- 11
0
votes
1
answer
742
views
empty realm part not allowed Issue with Kerberos Authentication over DB2 Server
I am trying to connect to Db2 server over a Kerberos Environment. I am using DB2SimpleDataSource in my code to get a connection to my DB2 server. As per my current understanding, if I have a kerberos ...
0
votes
1
answer
694
views
DB2 developer community edition hangs at "Starting docker containers..."
DB2 developer community-edition hangs at "Starting docker containers..."
Ubuntu 16.04 LTS x64 , bare-metal, Xeon E5-2660 cpu. 128GB RAM.
Docker version 17.06.2-ce, build cec0b72
Using: ibm-db2-...
- 121