Questions tagged [db2]
The db2 tag has no summary.
18 questions
1 vote
0 answers
241 views
The db2prereqcheck utility was unable to determine the Linux distribution level
I am trying to check prerequisites before installing IBM db2. I got this error DBT3505E The db2prereqcheck utility was unable to determine the Linux distribution level. % I'm using XeroLinux (newbee)...
- 11
0 votes
1 answer
574 views
Bash script permission denied
I'm trying to check all counts for all tables in IBM DB2 using Red Hat Linux. When I try to run this DB2 SQL Script db2 "SELECT 'SELECT COUNT(*) AS ROW_COUNT FROM '|| tabschema || '.' || tabname ...
1 vote
1 answer
7k views
Fail to yum install libstdc++.so.6 when installing db2 v11.5 in redhat OS
Good day, I am trying to install DB2 V11.5 (64 bit) in red hat OS. However, I having some warning message as follow: Summary of prerequisites that are not met on the current system: DBT3514W ...
- 113
1 vote
1 answer
2k views
Passing parameters inside db2 SQLs from an unix shell script
I want to delete certain rows from a table based on my input values to a unix shell script. I am making connections and terminating it inside my shell script. If you notice right now the field is ...
-1 votes
1 answer
2k views
db2start fails with error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory
Installed db2 10.5 but installation completes with warning that db2start failed while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory. i have both ...
- 101
0 votes
2 answers
427 views
Which DB2 client package is needed to compile embedded SQL programs?
I have to work on some embedded SQL files (.sqc) for DB2 which will be compiled on Linux. The DB2 command line processor (db2 command) has to be used for precompilation. What of the many DB2 client ...
- 113
1 vote
3 answers
4k views
Execute a database query by iterating through results of a previous query
I'm new to Unix and bash scripts so please bare with me if this is a silly question. I've just started working for a company that uses DB2 hosted on a Unix platform and there are a lot of unwanted ...
- 111
2 votes
1 answer
5k views
Storing longer text output in memory in shell variables vs Writing to disk
I have the below call to db2 database command line tool inside a loop, which runs 100k iterations. (the output from db2 is 5 rows of 20 chars approx per each call, total of approx 100k calls. The ...
- 155