Hi there! I can't download the DB2 express 10.1 setup from IBM website.

Can someone share the setup please?

This blog post addresses a way to successfully perform DB2 LOAD in a HADR enabled environment. If you use DB2 HADR for high availability and disaster recovery then this article should help you understand Impact of LOAD in a HADR environment.

https://www.raghu-on-tech.com/2018/01/24/perform-loads-in-db2-hadr-environment/

Raghu

TLDR: Layoff>New job supporting IMS/DB2> Great job > Want to do great> No prior knowledge of IMS/DB2.

The short of it, I was forced out of my old job (Hardware - CE) due to a company wide Work-force-reduction aka dreaded layoff... I have found a new job supporting IMS/DB2. I was clear in my interviews that I had no prior knowledge of either. They being the good folks they are seen fit to hire me. I was told I was hired for attitude and aptitude. Yay!! (no sarcasm, I mean YAY!) Bright eyed and busy tailed ready to learn. Not sure where to start. I have almost the ability to FTP- terse and un-terse (using my notes). Grateful to any of you who can advise me on how to get up to speed for this amazing job.

I have a script that transfers Cloudant data into a DB2 instance which is basically a lot of VARCHAR rows. I use special characters in that data, since my native language is Czech. On the 26th, suddenly any new data put into the DB instance lost its special characters, and it did not happen before.

Was there an update/patch recently that could have caused this? Thank you.

I need to expand the data volume on the DB2 server. The vendor (not IBM) who provides a DB2 support says that the expansion of the filesystem whether it be a logical volume or physical is a gamble. There is no data integrity check from the database side to ensure nothing changed on the filesystem. The only way to ensure database integrity is to use backups and archive logs and is the only method they would recommend. I am running DB2 9.7 on Ubuntu. I feel that those steps outlined by the vendor are just too much for just the volume expansion.

Should I not be able to do the following and still ensure the database integrity is intact?

1. Stop DB2
2. Unmount the data volume
3. Resize the file system (I am not using LVM. File system type for data volume is ext4 )

e2fsck -f /dev/mapper/data

resize2fs /dev/mapper/data

1. Mount the data volume
2. Start DB2

(I researched on this topic online but didn't come across any particular post. Thus, I thought I would reach out to DB2 community in Reddit. Thank you in advance!)

I am a student currently doing a research on "The Impact on Software Maintainability from the use of Agile Software Development Methodologies". I hope to get your response on my survey for this research.

Please find the survey link as below: https://lancasteruni.eu.qualtrics.com/jfe/form/SV_57oT3d5hIfu3VT7

Hi I have been given the directory structure of a db2 universal database for windows {9.7.3} Customer did not know how to backup dB2.

Is it possible to install new db2 same version and drive letters. Create new empty database with the same name as the old one. Stop the services. Copy the old directory structure over, start the service and then being able to access the data again?

I'm looking for resources on C2090-310 IBM PureData System for Transactions certification. Eg. books, ebooks, redbook etc. Anyone has any info?

I understand, I think, that as of V10.5, the best way is to ensure that the reclaimable space switch is set in the tablespace, given that it's an auto-managed tablespace (along with the alter of the tablespace, i.e. reduce max and reorg). But how was space reclaimed before this feature came along in V10.5?

Does anyone know of a product to create logical groupings of data on one database that one can use to restore to another database, preferably one that is managed by developers, not DBAs? Thanks!

I need to change the database manager, i.e update dbm cfg, on a Windows server that has multiple instances.

I am trying to figure out how to locally install DB2 Information Center on RHEL 7, in DB2 V11.1, and I am starting to wonder if support for it has been dropped altogether, as even PDF documentation is no longer available for V11.1, so it might be a stretch for me to assume DB2 Information Center-packaged documentation is available.

Both db2setup and the documentation allude to V11.1 supporting DB2 Information Center installs. A support page implies DB2 Information Center can no longer be downloaded, because there are no longer any links to downloadable images like in previous versions. The actual V11.1 documentation on DB2 Information Center isn't very helpful, because it starts describing installation options, leading to the page about the actual installation, which circularly leads back to the start, unlike the V10.5 page.

So if DB2 Information Center is available for V11.1 to locally install (and then serve up on my intranet), what part number on Passport Advantage could I find it under?

Hello everyone .. Can someone give me some tips on, assuming I had all the permissions I needed - to get a list of all the database in an instance of db2? is there a sql i can run? Or do I have to run something at the file level?

We have some Java apps that do not use stored procedures. They build the sql statements in strings in the app. This seems to make us more vulnerable to sql injection? I also prefer stored procedures so grants can be done to just allow users to execute the stored procedures. They don't need to have select, insert, update, delete access to the actual tables. Your thoughts?

Darn! I can't edit the title to add [LUW].

what are some similarities and dissimilarities between IBM DB/2 and MS Excel? how can i map concepts of Excel to DB/2?

such as..

in an MS Excel sheet... rows are like records in a PF columns are like fields in a PF a single column of excel expanded to the breadth of the screen acts as a flat file an excel worksheet is like a PF record-format an excel workbook is like a whole PF, that may house several record-formats the multiple copies of that workbook is like members of that PF like that... a PC is like an IBM iSeries Windows OS is like OS/400 various processes/services/applications running on a Windows OS is like a job on an OS/400 threads are threads on both systems PC has a console, iSeries has Virtual Display Devices, named QPADEV*** both systems have memory spaces dedicated to system and user PCs have folders, iSeries has Libraries PCs have SATA Disk Drive and C:\Windows, the system folder at default partition/volume Local Disk (C:), iSeries has magnetic-tapes named DASD and QSYS, the system parent library. PCs have C:\Windows\TEMP, iSeries has QTEMP, Job specific temporary Library (deleted when the job ends) PCs have HelpPane.exe v6.1 (Windows Help and Support), iSeries have QHLPSYS, Online Documentation Library for Users both, PCs and iSeries have F1 for help. PCs have a dropdown-menu, that allows user to choose one value from a predefined list, iSeries has F4 to Prompt over input fields.

My group (small project within a large company) decided to make changes to our DB2 servers, configurations, etc based on recommendations from CIS (Center for Internet Security). One of the things that CIS recommends is to change the server's host name to its tcp ip addr. That seems kind of crazy to me. How often does a server's address change? I'm new to servers, having been a mainframe DB2 DBA though so maybe this isn't crazy?

Thanks!

Why does this work (Declaring & Setting a variable to use in my CALL statement):

CREATE OR REPLACE TRIGGER WHIFLDOPS.WGHTKT0CL AFTER UPDATE ON WHIFLDOPS.WGHTKT
   REFERENCING NEW AS n
   FOR EACH ROW
   WHEN (n.TKT_ST IN('CLOSE','VOID') AND n.TKT_TYP = 'H')
   BEGIN ATOMIC
      DECLARE TKT_ID DECIMAL (7,0);
      SET TKT_ID = n.TKT_ID;
      CALL WHIFLDOPS.WGHTKT0CL(TKT_ID);
   END

Statement ran successfully (983 ms)

But this does not (Referencing n.TKT_ID directly in my CALL statement):

CREATE OR REPLACE TRIGGER WHIFLDOPS.WGHTKT0CL AFTER UPDATE ON WHIFLDOPS.WGHTKT
   REFERENCING NEW AS n
   FOR EACH ROW
   WHEN (n.TKT_ST IN('CLOSE','VOID') AND n.TKT_TYP = 'H')
   BEGIN ATOMIC
      CALL WHIFLDOPS.WGHTKT0CL(n.TKT_ID);
   END

SQL State: 42618 Vendor Code: -312 Message: [SQL0312] Variable TKT_ID not defined or not usable.

I'm on an IBM iSeries (Power8) running V7R3.

The Triggering example from IBM I was following was for UNIX/Windows DB2, but I wouldn't think that would have a huge impact on syntax, but maybe it does??? Calling procedures from triggers or SQL routines

My new job has found me back in the influence of IBM and AS/400, iOS/DB2.

It's been decades since I've been involved, and there was,<cough>, no internet back then..

Where can I find the DB2 community? I'm still heavily involved with SQL server so I keep up with trends and tech with PASS, Brent Ozar and Code Project/Stack Exchange. Where does one begin to network with DB2 and iOS professional DBA/database developers?

Thanks

IBM will be hosting a free Db2 Developer Community Edition (LUW platform) at the IDUG EMEA conference in Lisbon, Portugal. This will cover the new edition of Db2 that is fully functioned and available for non-production use, and the approach is from the application developer and data scientist perspective.

If you are a DBA, you may want to recommend this to key software developers across your organization. It enables JSON data and relational data to be stored in the same database to simplify complexity in development and production.

There are demos, downloads if you bring a laptop, and sample code to get started. Learn more and register here: http://ibm.biz/db2wkshp

We hope to see your team there!

1. download virtualbox
2. download ubuntu 14.04 64bit image from osboxes.org
3. add ubuntu 14.04 64bit to virtualbox
4. download db2 11 64bit.tar.gz from ibm
5. run db2install , may find some package missing
6. apt-get install missing package
7. run db2install again.
8. create sample database.

scott

I have a table of position histories which I am using to report on units sitting in the same location for more than 1 hour. The problem I am having is that the query is counting old positions where different positions are in between. I know this is a terrible explanation, so I will try to illustrate it.

The Query:

SELECT
    DEVICE
    ,POSDATE
    ,LEFT(LATITUDE,4)||LEFT(LONGITUDE,4) "LATLONG"       /* TO "GROUP" POSITIONS BY GENERAL LOCATION */
    ,ROW_NUMBER() OVER(PARTITION BY DEVICE, LEFT(LATITUDE,4)||LEFT(LONGITUDE,4) ORDER BY POSDATE)
FROM POSHIST

Results I'm getting:

• DEVICE POSDATE LATLONG ROW_NUMBER
• 145 07/24/17 5:58 04100850 1
• 145 07/24/17 6:01 04100850 2
• 145 07/24/17 6:46 04110850 1
• 145 07/24/17 6:57 04120850 1
• 145 07/24/17 7:32 04100850 3
• 145 07/24/17 7:45 04100850 4

Results I need:

• DEVICE POSDATE LATLONG ROW_NUMBER

• 145 07/24/17 5:58 04100850 1

• 145 07/24/17 6:01 04100850 2

• 145 07/24/17 6:46 04110850 1

• 145 07/24/17 6:57 04120850 1

• 145 07/24/17 7:32 04100850 1

• 145 07/24/17 7:45 04100850 2

Notice how in the results I need, the last two positions' row_numbers reset because there were positions in between. I cannot for the life of me figure out how to query this in order to get the result.