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

DB2 trigger error

i have the following trigger that triggers an insertion on THAT_TABLE whenever there's an insertion or update to THIS_TABLE. The following query works as is the way it should. Likewise-- it works when i comment line-A and uncomment (and remove or…
user6401178
  • 183
  • 2
  • 11
-1
votes
2 answers

select not working after putting where condition in nicknames?

I have a remote mainframe db2 database for which I have created nicknames in my db2 server . Problem is as below - When I run query SELECT * FROM LNICKNAME.TABLE - It runs and I can get all columns. but if I run below query it never gives me any…
Bibek Panda
  • 519
  • 4
  • 10
-1
votes
1 answer

IBM DB2 v9.5 requires admin rights to run every time?

How can we install IBM DB2 v9.5 express edition database so that we can access DB2 directly without admin rights? (Please note I want to access without admin rights) Thanks
Akshay Lokur
  • 6,680
  • 13
  • 43
  • 62
-1
votes
1 answer

renaming column for a partitioned table

I have a partitioned database environment with partitioned tables. Can I alter the column name for the table. I am aware that I cannot do that in following condition: it is being used in any views it is referenced in any in index definition it is…
Aryadhara Das Adhikari
  • 1
-1
votes
1 answer

GROUP BY clause failing mysteriously in IBM dashDB

Theoretically, I should be able to run a GROUP BY clause in dashDB's SQL syntax. This works: SELECT MESSAGE_BODY, MESSAGE_RETWEET_COUNT FROM COOLSCHEMA.DRIL_TWEETS ORDER BY MESSAGE_RETWEET_COUNT DESC LIMIT 100; However, this does not: SELECT…
huertanix
  • 761
  • 1
  • 9
  • 22
-1
votes
1 answer

Failed to create DB2 datasource in weblogic 10.3.6

I am trying to create a DB2 Data source in weblogic 10.3.6.But I am getting error "cann't load db2 driver". Here I am using Oracle's DB2 (type 4) JDBC Driver. I have provided valid hostname, db2 name and port in connection pool. Also I kept…
user6163639
  • 1
  • 3
-1
votes
1 answer

Insert array of JSON objects in db2 stored procedure

I'm trying to pass an array of JSON objects to the Stored procedure, so that each JSON object will be stored in a single row of the table. for an example: to insert a single entry: INSERT INTO SCHEMA_NAME.TABLE_NAME (id,name) values…
user2881430
  • 367
  • 1
  • 5
  • 17
-1
votes
1 answer

DB2 64-bit for Windows

Does DB2 comes in 64-bit flavor for Windows environment ? What is the best way to locate installable/executable for the same? Also, DB2 ODBC Driver I found only 32-bit flavor of it on fix centeral using this link . Is there a 64-bit flavor of it…
Gaurav Daga
  • 343
  • 2
  • 11
-1
votes
2 answers

Can I disable QUERY OPTIMIZATION for MQT in DB2 LUW without recreating it?

UPDATE from 2021 This question is no longer actual for me. It was a short period when I worked with DB2 and I don't know how it's in recent versions. The problem was: I could not test effect of MQT without rebuilding it. Which was not practical when…
Alex Yu
  • 3,412
  • 1
  • 25
  • 38
-1
votes
2 answers

DB2 database backup encryption

I want to take encrypted backup of my existing database which is not encrypted. db2 backup database sample encrypt does not work, it gives me an error: "SQL0104N An unexpected token "encrypt" was found following "SAMPLE". Expected tokens may…
Masheed
  • 35
  • 3
  • 13
-1
votes
1 answer

Configuration of SSL in DB2 LUW

I am configuring SSL in db2 AIX server. Getting the following error in diaglog: "gsk_secure_soc_init" failed with error code "410" in "sqlccSSLSocketSetup" DB2 version:9.7 FP10 All SSL parameters are set and have generated self signed…
Shridhar Kulkarni
  • 21
  • 6
-1
votes
2 answers

fetch the data for past three hours only from current time stamp from db2 tables having timestamp column is of Char datatype

I am using below query : Select a."System_Name", a."Comp_Mem_Pct", b."CPU_Usage", SUBSTR(a."Timestamp",2,2 )||'-'||SUBSTR(a."Timestamp",4,2)||'-'||SUBSTR(a."Timestamp",6,2) AS date_ from "ITMUSER"."Unix_Memory" a, "ITMUSER"."SMP_CPU"…
Tom123456
  • 77
  • 1
  • 9
-1
votes
1 answer

Data movement utility in db2

Why the not logged initially option during the data movement is faster than using the LOAD utility in DB2? Not logged initially Method: db2 alter table tablename activate not logged initially db2 insert into table tablename select * from…
Tom123456
  • 77
  • 1
  • 9
-2
votes
2 answers

Converting a numeric value into Date value in DB2

I have a DB2 table where NUM column is defined as INTEGER in DB2 and the query result is shown below, NUM columns have numeric values which needs to be converted to date format. This numeric values are nothing but duration from 01.01.1850. Example…
MaMu
  • 31
  • 3
-2
votes
1 answer

Alternative to IBM Data Studio

I use IBM Data Studio (4.1.3 and 4.1.4) to develop stored procedures (native) and functions on DB2 Z/OS (V12) and DB2 LUW. Unfortunately Data Studio is slow and keeps crashing. Do you know valid alternatives that can be used on both Z / OS and LUW…
killer
  • 11
  • 6
1 2 3
…
60
61