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

spring-boot jdbc connection to db2 gets read timeouts

So I'm new to db2 and have to use it in a project soon, in order to prepare myself I used a db2express-c docker image. From a soon to be co-worker I received the JT400 library to connect from my application to the docker container. However I keep…
J.Pip
  • 4,523
  • 7
  • 31
  • 49
-1
votes
2 answers

IBM DB2, create an alias to database with schemas and tables

I have a database (list db directory): Database 4 entry: Database alias = ABC Database name = ABC Local database directory = /data Database release level = f.00 Comment …
przemaz
  • 390
  • 5
  • 11
-1
votes
1 answer

export records from a table by modifying without double quotes for the numeric columns from the table in db2(udb)

I am trying to remove the double quotes for the numeric columns using export command by using replace function but it wont worked out, below is the query I used in Linux environment, EXPORT TO…
user9419188
  • 27
  • 4
  • 14
-1
votes
1 answer

DB2 select row isolation not working

going by this link I should be able to isolate the rows which are being read using a select statement but when I run below steps it doesn't lock the rows create table test ( col varchar(50)); INSERT INTO test values('100'); select COL from…
Waseem Ahmed
  • 57
  • 10
-1
votes
1 answer

ADFv2 SSIS-IR and DB2 Driver IBM DB2 ODBC DRIVER - DB2COPY1. SSIS package Unexpected Termination in prevalidate

Using ADFv2 SSIS-IR and DB2 Driver IBM DB2 ODBC DRIVER - DB2COPY1. Have defined the TCPIP Nodes and database using db2cmd DB2 CATALOG commands. Defined 32-bit and 64-bit SystemDSNs. The st.err and st.out from the SSIS-IR provisioning show all…
SQLAdventurer
  • 1
-1
votes
1 answer

access denied (permission issue) in db2

I'm new to DB2 and have installed the DB2 developer edition. I launched the DB2 command line - admin created an instance and switch to that instance. Then I'm going to create a db under this instance but it gives me the following error…
HHH
  • 6,085
  • 20
  • 92
  • 164
-1
votes
1 answer

Getting Error While creating table in db2 with the datatype

I am new to DB2. I tried creating a table with the following query: CREATE TABLE CLP.legal_bill_charge( client_id VARCHAR(11), client_division_id VARCHAR(11), client_office_id VARCHAR(11), matter_id VARCHAR(11), legal_bill_charge_id VARCHAR(13) NOT…
user9419188
  • 27
  • 4
  • 14
-1
votes
2 answers

Converting from lower to upper case in Sql Editor in Data Studio

What keyboard shortcut can I use to switch from lower to upper case and upper to lower case in Sql Editor in Data Studio LUW ?
Ina
  • 1
  • 2
-1
votes
1 answer

Linux DB2 Shell Script

I want to put the following SQL statements into a shell script using only one variable that I can mail to 3 people as part of my daily health checks on our client side. Please help me out with the ideas here. I also want to add 2 commands to check…
user7611057
  • 1
  • 2
-1
votes
1 answer

DB2 alter a stored procedure

I am new to DB2 and am stuck in altering a stored procedure. I am on DB2 9.1 version, AIX. I wrote following SQL in Toad (free version): ALTER PROCEDURE THE_USER.BONUS_MAIN ( ) REPLACE VERSION V1 ( ) MODIFIES SQL DATA CALLED ON NULL INPUT …
Paul Z
  • 27
  • 2
  • 9
-1
votes
1 answer

Which specifications must I do in db2dsdriver.cfg to connect to aDB2 database? I get SQL1532N error

I installed Python 3.4 and ibm_db to connect to a DB2 database; I saw in Python interpreter that ibm_db 2.0.7 is installed, but during connection to a DB2 database, I got the SQL1532N error message, so I think I need to configure db2dsdriver.cfg and…
babacim
  • 11
  • 1
  • 5
-1
votes
1 answer

Unable to allocate new pages in table space "XXX" IBM DB2 SQL Replication

Product: IBM DB2 OS: Windows 2008 R2 I am trying to perform SQL replication on my database, I have created the capture tables, while I am trying to register the tables I got the following error message [IBM][CLI Driver][DB2/NT64] SQL0289N Unable…
Mian Awais
  • 9
  • 9
-1
votes
1 answer

How to set up DB2 10.5 programming environment for XA transaction manager?

I want to use DB2 10.5 on Linux for XA transactions. Does DB2 include a XA transaction manager? How can I setup my C application for a XA transaction environment?
thibaultG
  • 13
  • 2
-1
votes
1 answer

DB2 Import (Raw) XML Data

Is there a way to import (or load) raw xml data into a table with a column of type xml. Kathy Smith5…
Finn von Holten
  • 108
  • 10
-1
votes
1 answer

DB2 restore command fails on Windows 10

Installed DB2 Express C v10.5 and also v11.1 on Windows 10 PC. Database backup is successful but Restore ends with error with both versions. I also tried the same using Data Studio 4.1.2, but here also backup is successful but restore command is…
asthac
  • 31
  • 8
1 2 3
…
60 61