Articles & Content

StackOverflow

StackOverflow is a collaborative programming Q&A community venture

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
DB2 Federation error in creating Nicknames

We are setting up the federation in order to browse data from ADABAS using DB2 federation. We have a Classic Data Architect connection set up and a remote server in DB2 federation configured usign JDBC.The problem is that when we try to create a nickname using this command:

CREATE NICKNAME "JADABAS"."[TABLENAME]" FOR "CACDSJ"."ANAG"."[TABLENAME]";

we are getting this error:

The current transaction was rolled back because of error "-430".. SQLCODE=-1476, SQLSTATE=40506, DRIVER=3.68.61

The DB2-server is a windows.

any ideas?

here the logs:Google drive log link

DB2LEVEL output:

DB21085I This instance or install (instance name, where applicable: "DB2") uses "64" bits and DB2 code release "SQL10059" with level identifier "060A010E". Informational tokens are "DB2 v10.5.900.618", "s170908", "IP24033", and Fix Pack "9". Product is installed at "C:\IBM\WSII\V10.5" with DB2 Copy Name "DB2COPY1".

How to change timestamp column size in DB2?

Any idea how to change timestamp column size in DB2?

I tried altering table, drop and then create table. Both didn't work.

Here are the queries I've tried:

alter table clnt_notes alter column lupd_ts set data type timestamp(26)create table CLNT_NOTES (NOTE_ID int not null generated always as identity (start with 1, increment by 1), CLNT_ID varchar(10) not null, TX varchar(200), LUPD_TS timestamp(26) not null)
Invalid operation result set is closed errorcode 4470 sqlstate null - DB2 data extract

I am running a very simple query and trying to extract the results to a text file. The entire query is essentially what is below, I am selecting everything from one single table with one piece of where criteria which is limiting the data to one month's worth. After it has extracted around 1.2 gig this error shows up. Is there any way that I can work around this other than extracting smaller date ranges? I am trying to pull a couple of years worth of data so if I can only get it a few days at a time it will take a lot of manual work.

I am currently using the free trial of a DB2 query tool - Razor SQL if that makes a difference, I can probably purchase different software if it would help. I am trying to get IBM's tool but for some reason it freezes during the download so I am still working on that. I have searched about this error but everything I see seems much more complex than what I am doing and I can't tell if it applies or not. Thanks in advance.

select *from MyTablewhere date_col between date '2014-01-01' and date '2014-01-31'
How to find the name and value of a table's primary key in DB2

How can I find the primary key column name and value of a table? I have tried looking in the SYSCAT table but cannot find anything on this.

How to connect C# with db2 database? [on hold]

I have found a new job where the IT team works with a IBM DB2 database over AS400 iSeries version V6R1m0 and I want to connect C# with that database, I'm too confused because there are a lot of terms that I don't understand; I have found terms like .net data provider, IBM Data Server Client, IBM Data Server Driver for ODBC and CLI and ibm i access for windows; for that reason I have multiples questions

-What is V6R1M0?

-What driver should I install on my laptop to connect the database?

-Are the drivers to be installed in the operating system or are libraries for C #?

-Where and how do I download and install the driver? Is it free?

-How do I build the connectionString inside C#?

-Are there different ways to connect with the database?(ODBC, OLEDB, any other)

I am very grateful that you explained to me and resolved my doubts

writing SQL queries in db2 database

I'm new be to DB2/AS400. I know writing sql queries to insert/update in the database but not sure how could i perform same thing in DB2/AS400.Can any body guide me how could i write the sql insert/stored procedure queries in db2 database

DB2 behaves differently through client and CLI

I have faced this problem few times. So what I'm intrigued that why does DB2 behave differently while executing same commands from Squirrel and CLI. I'm working with Windows 10 and DB2 LUW version 9.7

This particular problem I'm facing is with with timestamp format:

This insert works when I run it from Squirrel but not from CLI:

INSERT INTO TABLE_A(CREATION_TIME) VALUES ({ts '2018-04-16 17:03:22.066000'})

I have generated the insert statement from Squirrel using "Copy as SQL INSERT-VALUES statement". The coltype is TIMESTAMP.

In general, there are other differences as well. For example statementREORG TABLE TABLE_A works only from CLI but not from Squirrel.

Could someone enlighten me where this different behavior derives from and is there some documentation which would help me to understand the phenomenom?

what could be the TPS count of DB2 database to handle large number of hits

I would like to know what could be the TPS(Transactions per second) count of DB2 to serve / handle data requests from 1000000 hits?

I am very new and try to understand the significance to realize the TPS for high availability to serve the data from DB2 database.

Setting Up Flask DB2 connection

I am trying to connect my flask application to a DB2 database,but somehow I am unable to do. here is what I am trying to do,I am using flask extension flask_db2 for this purpose and below is how I am trying to connect

from flask import Flaskfrom flask_db2 import DB2app = Flask(__name__)

@app.route('/')def index() cur = db.connection.cursor("DATABASE=name;HOSTNAME=host;PORT=60000;PROTOCOL=TCPIP;UID=username;PWD=password)

How to retrieve initial Db2 on Cloud password

Which is the initial password for the Db2 on Cloud profile?I'm trying to connect via DSM (Database Server Manager).

IBMid and e-mail didn't work. Where can I find the username and password?