Stack Overflow
Stack Overflow

Questions tagged [db2-luw]

DB2 for Linux, UNIX and Windows

DB2 for LUW is part of the DB2 family, that runs in these operative system.

Many parts of the internal structure are the same in all members of the DB2 family, but there are also things specific for each architecture.

This tag is for question related specifically to this member of the family.

913 questions
-1
votes
1 answer

Table valued Parameters equivalent in db2

I am trying to pass a collection of Employee objects from Java code to a DB2 Stored Procedure. In SQL server I can do that by making use of Table-Valued Parameters. In DB2 how can I achieve this?
Pavan Kathi
  • 51
  • 1
  • 6
-1
votes
1 answer

How would i read lines only starting with B or R using Python

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID B D 20200518123514001 N D S0000026.LOG S0000026.LOG Contains 4 tablespace(s): 00001 SYSCATSPACE 00002 USERSPACE1 00003 GOSALES_TS 00004 SYSTOOLSPACE Comment: DB2…
Shadain
  • 11
  • 4
-1
votes
1 answer

Java JDBC executeUpdate arraycopy: length -1434 is negative

I've got problem with calling stored procedure in DB2. If i run it without java, it'll work fine. Can someone help me with that? The problem does not depend on message variable and i can't get whats wrong with it. Here's the code: CallableStatement…
norvd
  • 3
  • 3
-1
votes
1 answer

Shell Script: how to Input Variable value from file to run sql with the supplied variable

I have a text file with two columns and 'n' number of data. I'm running one shell script that fetches the data from the file and input variable defined in the shell script. My Data Arranges as follows HX_EXT TX_EXT HX_GAMER TX_GAMER HX_SALE…
MOHAMMAD SHAMSHAD HUSSAIN
  • 3
  • 4
-1
votes
1 answer

DB2 (version:11.5.0.1077) Command LIST ACTIVE DATABASES is not working

I downloaded trail version of DB2 (by following steps here:https://www.db2tutorial.com... some steps didn't come when i installed)and i opened Administrator:DB2 CLP - DB2COPY1 -db2, then i have given the cmd as db2 => LIST ACTIVE…
Devi George
  • 45
  • 2
  • 8
-1
votes
2 answers

Passing parameter received from shell script to a db2 query inside same shell script

I am writing a shell script which takes 1 parameter table name. Inside the same shell script I have a db2 query - "Select * from table_name". I want to provide a table name for db2 query which I received from shell script parameter. How do I achieve…
mandar munagekar
  • 79
  • 10
-1
votes
1 answer

How to get the restult table of a stored procedure into a temp table?

Enviroment: DB2 Version 11.1, OS - Linux How to get the result table of stored procedure into a temp table? The table and the result have the same table configuration (firstColumn int, secondColumn nvarchar(255))
michael-mammut
  • 2,595
  • 5
  • 28
  • 46
-1
votes
1 answer

How to write DB2 DDL & DML audit logs as System Application Logs?

I am using DB2 LUW in a windows machine. I want to get the logs for DDL & DML queries used in the database. The default logs(for example S000001.LOG) contains 'null' and not in a readable format. So I enabled auditing and extracted the archived…
Selva
  • 25
  • 6
-1
votes
1 answer

Hibernate is locking the whole table for a transaction and doesn't even let read data of that table

My application is using hibernate 3.6.10 and database is db2. Isolation level is default i.e 2 (Read Uncommitted). if i initiate a transaction to insert/update in table, i can't read data from that table until the transaction is committed. All i…
Abdulrauf hashmi
  • 58
  • 8
-1
votes
1 answer

Can't load boolean values from csv into table in db2

Trying to load csv with boolean column that has entries like this 1,10044.71556451,True When using LOAD command I get the error SQL27924W The value in row and column 3 could not be converted to a Boolean value, and the target column is not…
Omar Ahmad
  • 358
  • 1
  • 2
  • 11
-1
votes
1 answer

How to list view tables in DB2

I am required to list down all the tables created by view. I know SYSIBM.SYSTABLES will list down all tables, but which field in SYSIBM.SYSTABLES is used to identify that the table is created using view? Note: I am using DB2 V10.5. Edit: Reply to…
karfai
  • 816
  • 1
  • 10
  • 21
-1
votes
2 answers

Db2: Query for searching table with different column name

In my database, all tables should have a column (let's say "abc") and I want to find out the tables which do not have this column. Do we have any such query to fulfill this requirement? Database: Db2 v11.1 LUW
Jasbeer Chauhan
  • 1
-1
votes
1 answer

How to return a result set of a table in DB2-LUW without using a cursor?

I'm trying to create a stored procedure in DB2-LUWv10.5. I need to return a result set of a table without making use of a Cursor(WITH RETURN). I am running the below code on DB2-LUWv10.5. When I use Approach2, it runs fine and returns expected…
Nikhil
  • 11
  • 3
-1
votes
1 answer

Update on table error with db2 CLI/ODBC Connection from C Application?

Getting error while updating a remote database from C application connected through DB2 CLI/ODBC Driver. The error occurs with the function SQLExecute of the UPDATE-statement (returns -1). SQLSTATE: 42828, Native Error Code: 4294966786, [IBM][CLI…
MOHAMMAD SHAMSHAD HUSSAIN
  • 3
  • 4
-1
votes
2 answers

DB2 SYSADM Windows - NO LUCK

I have installed DB2 10.5 Enterprise Edition on a Windows 2012 server but can't get a SYSADM access with anything. I also have restored a DB2 database taken from a similar server to the new one but can't gain SYSADM permisisons to browse data. The…
Kevin D
  • 1
1 2 3
…
60 61