Get empowered with IBM Power
I have gone through the documentation of this software on IBM’s website. i have gone through it but there are hardware requirements specified for this software. I have to procure a machine for it and I need to know the details of a system requirement for it i.e process ,ram ,virtualization card etc
submitted by /u/Fair-Lalajaat_1230
[link][comments]
I’ve been doing some migration work; porting a Db2 database to a PostgreSQL one. You could say that is going from an Enterprise strength solution to a simpler, but less expensive option, but it’s not a choice I’m in a position to ignore.
Customers are being presented with a wealth of database options as they migrate to the Cloud, and many of them are embracing the options of simpler and less licence hungry products.
There are many positives to PostgreSQL but there are some pitfalls in attempting such a migration.
Here are a few notes.
There are a few syntactical differences that I’ve stumbled over, but I suspect there are a lot more. Some examples are
Date functions e.g. YEAR aren’t available. To extract the Year from a Date or Timestamp you’d use
EXTRACT( YEAR from CURRENT_DATE ) or
DATE_PART(‘year’, CURRENT_DATE ) – 1
Date differences: in Db2 you might use
FULL BLOG POST TO BE FOUND HERE
Post Content
I’m very honored to be mentioned as one of the influential women on the IBMi platform! #ibmi techchannel.com/Admin/IBM/medi…
– Marina Schwenk (@MarinaSchwenk26)19:01 – Sep 20, 2022
Make Database Processing More Efficient & Get Your IBMi Space BackFiles that contain deleted records should be reorganized periodically. frees up wasted space, but more importantly it makes DB processing more efficient #BCSRWA ##systemadministrator #ibmi lnkd.in/evVQ_3tq
– BCS Group, LLC. (@bcsgroupllc)14:44 – Sep 20, 2022
