Last update.
Well it has been a learning experience - thanks to all the teachers.
Here is what I learned.
1) I didn't have to change anything it was all setup.
2) /etc/inittab is not in the picture in SUSE 12
3) All I really had to do was configure and start the DB2 Fault Monitor.
A) Sta
Je suis absent le 17 avril 2024.
--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www2.marist.edu/htbin/wlvindex?LINUX-390
I GOT IT!
I think these two files are the key.
cat /etc/inittab
ca:12345:ctrlaltdel:/sbin/shutdown -h now
fmc:2345:respawn:/opt/ibm/db2/V11.1/bin/*db2fmcd* #DB2 Fault Monitor
Coordinator
cat /etc/systemd/system/db2fmcd.service
# DB2 fault monitor
# Starts fmcd
# Note: any customizations to this
It just keeps getting weirder.
[ OK ] STOPPED DB2 V11.1.2.2."[ OK ] STARTED DB2 V11.1.2.2."
[ OK ] STOPPED DB2 V11.1.2.2."[ OK ] STARTED DB2 V11.1.2.2."
[ OK ] STOPPED DB2 V11.1.2.2."[ OK ] STARTED DB2 V11.1.2.2."
[ OK ] STOPPED DB2 V11.1.2.2."[
Hi Tom,
Absolutely no experience, but perhaps it should be something like:
ExecStart=/opt/ibm/db2/V11.1/bin/db2fmcd
based on
https://www.ibm.com/support/pages/db2-autostart-not-supported-red-hat-enterprise-linux-version-7
and przytula's post of June 6th, 2017 (#3)
https://ubuntuforum
I wrote a script that runs as a service like below to stop and start DB2 when
server is rebooted:
[Unit]
Description=Db2 shutdown and startup script
After=default.target
[Service]
User=root
Type=oneshot
ExecStart=/usr/local/bin/ start
ExecStop=/usr/local/bin/ stop
TimeoutStartSec=0
OK I am getting closer I think.
EXECUTABLE PATH SPECIFIES A DIRECTORY, IGNORING:
/OPT/IBM/DB2/V11.1/BIN/<=== I think it is telling me something is
missing here.
This is what's the /etc/systemd/system/db2fmcd.service file .. I think I
need a program name to run. Any idea what is
X-posted on z/VM list
-- Forwarded message -
From: Tom Huegel
Date: Fri, Apr 12, 2024 at 11:54 AM
Subject: Re: OT DB2 Autostart
To: The IBM z/VM Operating System
Well I think this is progress. It looks like DB2 is attempting to startup
but I have something wrong.
Can anyone
If you can’t undo what you did with the db2fm command (history command might be
your friend), then you can probably edit the file
/etc/systemd/system/db2fmcd.service and change it to 11.1
I can’t check a real server anymore to tell you for sure because we no longer
have db2 connect running so
Well I think this is progress. It looks like DB2 is attempting to startup
but I have something wrong.
Can anyone interpret these messages?
I see one problem at least, but don't know how to fix it. DB2/V10.5 sb
DB2/V11.1 I was doing some copy/paste from the instructions I think
that is
ovice. I need to have DB2 CONNECT autostart at LINUX boot
> time. How do I do that? LINUX is SUSE.
>
> --
> For LINUX-390 subscribe / signoff / archive access instructions,
> send email to lists...@vm.marist.edu with
It's quite a long time ago we had DB2 Connect, but the startup of DB2
connect was included in the regular Linux SYSV init startup. I guess the
scripts came with DB2 connect. I don't know if current versions are
adjusted to SystemD. But in any case, you need to include it in the
regul
You’ll want to look at “db2fm” in the db2 doc.
It’ll start it and keep it active if it crashes.
From: Linux on 390 Port On Behalf Of Tom Huegel
Sent: Tuesday, April 9, 2024 9:34 AM
To: LINUX-390@VM.MARIST.EDU
Subject: Start DB2 Connect at linux boot
I'm a LINUX novice. I need to hav
Which release of SUSE? Did the DB2 Connect package come as an RPM, or in some
other format?
Mark Post
> -Original Message-
> From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU]On
> Behalf Of Tom
> Huegel
> Sent: Tuesday, April 09, 2024 12:34 PM
> To: LINUX
You could do a cronjob that runs at boot. The command “crontab -e” will open
the cron editor then you put in your command after the cron syntax.
@reboot DB2 CONNECT command goes here
Thanks,
Angel Jara
From: Linux on 390 Port On Behalf Of Tom Huegel
Sent: Tuesday, April 9, 2024 12:34 PM
To
I'm a LINUX novice. I need to have DB2 CONNECT autostart at LINUX boot
time. How do I do that? LINUX is SUSE.
--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu wit
On Tue, Nov 3, 2020 at 8:46 AM Grzegorz Powiedziuk
wrote:
> Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7
> on Z and we are having big performance issues.
>
What about enabling SMT in z/VM ? Would 10 cpu db2 take an advantage of
this? On the p8 they had SMT
> Where can I look for potential relief? Everyone was hoping for a better
> performance not worse.I am hoping that there is something we can tweak to
> make this better.
Only because I didn't see it specifically in the thread yet, do you have
similar large page size support/tuning in both environ
y had for this database
when it was on the AIX. This number has been calculated by DBAs and it
seems ok. I am not sure how to tell if DB2 is happy with what it has or
not, but the linux OS is definitely not starving for memory.
that p7 was 9117-MMD. And I just found that it was ha
On Tue, 3 Nov 2020 at 21:27, Grzegorz Powiedziuk
wrote:
>
> In the performance monitor toolkit it shows around 12.000 diag x'9c' /s
> and 50 x'44'
> But at this time of a day everything is calm. i will check again tomorrow.
> Lot's of diag x'9c' would indicate too many virtual cpus right?
>
You
Diag 9C are low cost, Diag 44 not so much. 50 is a low number.
On 11/3/2020 12:27 PM, Grzegorz Powiedziuk wrote:
On Tue, Nov 3, 2020 at 1:58 PM Grzegorz Powiedziuk
wrote:
Thanks Christian.
There is no pagging (swapping) here besides just regular kernel's house
keeping (vm.swappiness =5 )
rh
On Tue, Nov 3, 2020 at 3:25 PM Jim Elliott wrote:
> Gregory,
>
> Yes, thrashing. :-)
>
>
I like my name better and it even fits better :)
I will keep an eye on page faults tomorrow but we are not overcommitting
memory at all. Unless something inside of db2 is cooking but in li
On Tue, Nov 3, 2020 at 1:58 PM Grzegorz Powiedziuk
wrote:
> Thanks Christian.
> There is no pagging (swapping) here besides just regular kernel's house
> keeping (vm.swappiness =5 )
> rhel 7 doesn't give me diag_stat in the debug filesystem hmm
>
> On Tue, Nov 3, 2020 at 12:37 PM Christian Borntr
Gregory,
Yes, thrashing. :-)
Jim Elliott
Senior IT Consultant - GlassHouse Systems Inc.
On Tue, Nov 3, 2020 at 2:07 PM Grzegorz Powiedziuk
wrote:
> On Tue, Nov 3, 2020 at 1:57 PM Jim Elliott wrote:
>
> > Gregory,
> >
> > The 9117-MMD could range from 1 chip/4 cores all the way up to 16
> chi
On Tue, Nov 3, 2020 at 1:57 PM Jim Elliott wrote:
> Gregory,
>
> The 9117-MMD could range from 1 chip/4 cores all the way up to 16 chips/64
> cores at either 3.80 or 4.22 GHz. If it has 15 cores, then it was likely
> the 4.22 GHz 5 chip/15 core version. Using 10 out of 15 cores (even at 100%
> bu
On Tue, Nov 3, 2020 at 1:35 PM r.stricklin wrote:
>
> I recently had a vaguely similar problem with a much smaller database on
> linux (x86, mysql for zabbix) that presented bizarre performance issues
> despite clearly having lots of resources left available.
>
> What our problem ended up being w
; On 03.11.20 14:46, Grzegorz Powiedziuk wrote:
> > Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7
> on
> > Z and we are having big performance issues.
> > Same memory, CPU number is down from 12 to 10. Although they had
> > multithreading ON so they
ory left and this one VM has
> 150G configured. It is about the same as what they had for this database
> when it was on the AIX. This number has been calculated by DBAs and it
> seems ok. I am not sure how to tell if DB2 is happy with what it has or
> not, but the linux OS is definitely
On Nov 3, 2020, at 5:46 AM, Grzegorz Powiedziuk wrote:
> DB2 is running on the ext4 filesystem (Actually a huge number of
> filesystems- each NODE is a separate logical volume). Separate for logs,
> data.
I recently had a vaguely similar problem with a much smaller database on linux
(x
links or open attachments unless you recognize the
source of the email and know the contents are safe.
**
Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7 on
Z and we are having big perf
On 03.11.20 14:46, Grzegorz Powiedziuk wrote:
> Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7 on
> Z and we are having big performance issues.
> Same memory, CPU number is down from 12 to 10. Although they had
> multithreading ON so they saw more "cpu
memory left and this one VM has
150G configured. It is about the same as what they had for this database
when it was on the AIX. This number has been calculated by DBAs and it
seems ok. I am not sure how to tell if DB2 is happy with what it has or
not, but the linux OS is definitely not starving for
Power 730 (8231-E2C) to a 10 IFL z114 the
Power system has 1.4 to 2.0 times the capacity of the z114.
Jim Elliott
Senior IT Consultant - GlassHouse Systems Inc.
On Tue, Nov 3, 2020 at 8:47 AM Grzegorz Powiedziuk
wrote:
> Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7
2020 at 8:47 AM Grzegorz Powiedziuk
wrote:
> Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7 on
> Z and we are having big performance issues.
> Same memory, CPU number is down from 12 to 10. Although they had
> multithreading ON so they saw more "cpus
Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7 on
Z and we are having big performance issues.
Same memory, CPU number is down from 12 to 10. Although they had
multithreading ON so they saw more "cpus" We have faster disks (moved to
flash), faster FCP cards
Yea, I don't have a pidfile and it all seems to keep track of which processes.
I used Type=forking
On 8/19/20, 11:03 AM, "Linux on 390 Port on behalf of Mark Post"
wrote:
On 8/18/20 10:47 PM, Grzegorz Powiedziuk wrote:
> Do you specify the pidfile and does the wrapper
> script up
On 8/18/20 10:47 PM, Grzegorz Powiedziuk wrote:
> Do you specify the pidfile and does the wrapper
> script update pidfile? Without it, systemd probably is not able to figure
> out if service is running or not and probably would make stopping the
> service with systemctl command difficult.
That sh
On Tue, Aug 18, 2020 at 8:53 PM marcy cortes
wrote:
> It's not fun...
>
> We have a .service file of type forking that calls a script of ours to
> start it and stop it.
> systemd is cool with that.
> However, if you stop and then start db2 outside of db2 it's no l
It's not fun...
We have a .service file of type forking that calls a script of ours to
start it and stop it.
systemd is cool with that.
However, if you stop and then start db2 outside of db2 it's no longer
associated with that service and systemd whacks its processes at shutdown
time,
Hello, I realize that this is not a typical s390 question but I hope that's
ok if I ask anyway. There is a high chance we have people here who run db2
on zLinux.
How do you solve auto start and more importantly auto stop of DB2 on
start/reboot/shutdowns ?
Seems like the autostart may be handl
r itself is a
> single file that should be named jconn4.jar.
>
> Thank you Tim, I appreciate your time. I passed along your message to our
db2 and application teams hoping that it will help them to figure it out.
Thanks!
Gregory
-
IBM includes this note in its support matrix for Db2 Federation (
https://www.ibm.com/support/pages/node/957245):
"For other data sources not listed in Table 4, customer can also use
federation server to access them and perform basic operations like
querying remote data via JDBC wrappe
Hello,
Does anyone have any experience with Sysbase ASE and zLinux?
We run Sysbase database on some other architecture but we have a db2
instance on zLinux which needs to be able to communicate with Sysbase via
this driver. This driver is not available in db2 federation.
I apologize if I am mixing
You also have the option to simplify, to connect directly to Db2 for z/OS
if you wish. Connecting via the Db2 Connect gateway/server is quite
optional; you don't actually need to get it working. :-) Db2 Connect
*licensing* is still required.
If you follow the direct/simpler path, then you&#
Can anyone give me help to connect from PHP on zLinux to DB2 on zOS ?
On my zLinux run Apache 2.2 and Db2 Connect Application Server Edition 9.7
The traditional connect throught db2 command line run successfully.
Thank you very much.
Nik
IBM Italia S.p.A. Sede Legale: Circonvallazione Idroscalo
z/OS assembler code will have to be rewritten.
Linux/z is usually ASCII, not EBCDIC. Think about all those CLC's.
If you start by rewriting the assembler code in C and go through the SQL to
find all the cases where LUW and DB2/Z disagree, your only remaining problem is
whither the JCL.
E
change the linkages, etc... and,
z/Linux is ASCII (there is an option on the Dignus assembler for
that.)
We also have a DB2 preprocessor that can run in the z/Linux environment,
but its target is the z/OS DB2.. I'm not sure how that might operate
with the z/Linux DB2.
- Dave R
Has anyone migrated a DB2 database from z/OS to Linux on z where the
application code was written in assembler? I am wondering if it is
possible to use the z/OS precompiler output with the DB2 database set up
on Linux on z? If this is not possible, what other alternatives have you
looked at
Hi Gerard,
We have been using these kernel parameters for internal accounts. It is
based on limit of 90% for DB2:
#!/bin/bash
# Configuring kernel parameters on /etc/sysctl.conf
shmmax="$(echo "(($(cat /proc/meminfo | grep ^MemTotal | awk '{print
$2}')*90)/100)*1024&qu
Greetings VM List!
We recently moved a database from DB2 9.5 running on SLES10 SP4 to DB2 10.5
(fix pack 5) running on SLES11 SP3, both under z/VM 6.2. We're having some
issues with increased memory consumption and wondered if anybody else had
noticed a similar trend. To give a l
What is the best GUI to manage DB2, and does it come with the standard
> > installation? If not, where do I get it? I'm a member of the IBM
> Academic
> > Initiative and have access to most IBM software.
> >
> >
IBM in the most current versions removed the control center GUI. try data
studio
it is a free download. you can find it in developer works.
On Sunday, September 7, 2014, Cameron Seay wrote:
> What is the best GUI to manage DB2, and does it come with the standard
> installation? If not,
What is the best GUI to manage DB2, and does it come with the standard
installation? If not, where do I get it? I'm a member of the IBM Academic
Initiative and have access to most IBM software.
--
For LINUX-390 subs
Nothing unique about z Linux here. List database directory cmd gets the db. Get
db cfg cmd gets the rest. Use info center for details.
Sent from Yahoo Mail on Android
--
For LINUX-390 subscribe / signoff / archive access instru
I'm just learning my way around DB2 for Linux on z. I am working with some
folks that need to connect to my server and need the following information:
DB2 Host Name. TCP Port for DB2, Database Name where I have the tables
with data
Thanks as a
db2 select \* staff
db2 select \* from staff
--
For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin
Try -
db2 select \* staff
On Jul 6, 2014, at 6:19 PM, Cameron Seay wrote:
> Any clues as to why I am seeing this?
>
> lnx049:/home # su -l db2inst2
> db2inst2@lnx049:~> db2start
> 07/05/2014 23:21:18 0 0 SQL1026N The database manager is already
> active.
>
Any clues as to why I am seeing this?
lnx049:/home # su -l db2inst2
db2inst2@lnx049:~> db2start
07/05/2014 23:21:18 0 0 SQL1026N The database manager is already
active.
SQL1026N The database manager is already active.
db2inst2@lnx049:~> db2 connect to sample
Database Conn
Does db2setup export PATHs etc? If it does then it needs to be invoked using:
. ./db2setup
This will cause the environment variables set in db2setup to last beyond its
invocation.
Neale
On Jul 6, 2014, at 4:56 PM, Cameron Seay wrote:
> You, sir, are a steely-eyed missleman. All works just as
/home//sqllib/adm/db2start is the location
> of that command.
> You'll need to know the name of the db2instance, mine is (most
> unimaginatively) "db2inst1".
> Your mileage may vary. Look for it and make the proper substitution.
>
> I think you'll need to make PA
you'll need to make PATH point there and to a couple other places
DB2 likes to find things.
I'd do this:
export db2inst=/home/db2inst1/sqllib
export PATH=$PATH:$db2inst/adm:$db2inst/bin:$db2inst/misc
Creating the variable "db2inst" just makes for less typing, you don'
I am installing DB2 10.5 fixpack 3 on SuSE 11 for s390. I run the
./db2setup command from the home director of the install and all appears
well. But when I try to start DB2 via db2start I get a "no command of that
name" response.
I have installed and run DB2 9.x many times on the s
Hi all,
The challenge with DB2 is the node-lock file which is going to include platform
specific information (ip address / DNS name). I'd guess that the way to do this
would be to have DB2 installed but without any instances created. You can then
script db2icrt / db2start / db2 -tvf myd
We have was7 and now was8, we have one installation each of was7 / 8 without
the profile and
clone this disk into a shared readonly, works great.
for db2 I don't know, but if leaving db2 turned off in the clone base, you will
be able to modify
any config before starting it, that should
ason
is we have have WAS 6.5, WAS 7, WAS 8, and WAS 8.5 servers.
Mark Workman
Shelter Insurance Companies
573.214.4672
mwork...@shelterinsurance.com
From: Dave Jones
To:
Date: 10/12/2012 01:52 PM
Subject:cloning WAS and/or DB2 zLinux servers
Sent by:Linux on 390 Port
Hello, gurus
Does anyone have any useful advice, hints, tips, etc., about cloning
zLinux servers that are supporting either WAS or DB2? Can WAS and DB2 in
fact even be installed in such a way that they can be replicated to
other zLinux guests easily?
Thanks and have a good weekend, too.
DJ
We converted from standalone client copies to DB2 Connect Server under zLinux.
Reasons:
1. Cost. The standlone copy was about $450 per. The server copy for 25 Named
user was around $2,250. A Named user is per user and cannot be shared. A 25
pack for concurrent users costs much more
Thomas,
We are an SAP shop. Years ago, we ran the full DB2 connect client on each SAP
application server. This would be a real pail at times when DB2 maintenance
came along. It was also a consumed quite a bit of disk space on the server.
Also there was the matter of the configuration that
On Behalf Of Tom Ambros
Sent: Thursday, June 21, 2012 7:43 AM
To: LINUX-390@VM.MARIST.EDU
Subject: [LINUX-390] DB2 Connect client, any sense in running server?
We're running the DB2 Connect client at the various distributed machines
that require it. Is there any sense in running the DB2
We're running the DB2 Connect client at the various distributed machines
that require it. Is there any sense in running the DB2 Connect server
product in a Linux on System Z guest to serve the other guests or the
distributed machines removing the client from those distributed devices?
I
Randy:
Linux questions are better asked on linux-390 list at Marist.
> In the "Curiosity 6.2 SSI question" thread, you mentioned
> Does that include DB2? If so, how are you automating the
> failover? Anyone else have automatic failover from a DB2
> primary to a DB2 secon
guest and making the
queries from the command line, then you need to add this line into the
users .profile :
//sqllib/db2profile
this will insure that all of the DB2 "stuff" is defined to the user session
Oh - welcome to my world since the description "our Mainframe DBA's who
hav
This is from our Mainframe DBA's who have had DB2 LUW thrust upon them.
---
I am new to zLinux and DB2 LUW. I have to create a user and give them select
permissions to various tables.
I believe I need to do a
useradd -G username -p password
So I have done that no pro
Behalf Of Malcolm
Beattie
Sent: Monday, August 01, 2011 7:57 AM
To: LINUX-390@vm.marist.edu
Subject: Re: [LINUX-390] DB2 Performance Questions
Shedlock, George writes:
> We are conducting a proof of concept for one of our divisions. This includes
> DB/2 9.7 and Suse 10 SP 3 with CKD das
If we then try to turn it off, it is again flagged as an
> invalid option.
Unless things have changed recently, DB2 V9 for LUW on Linux for
System z only supports "no file system caching" (i.e. direct I/O)
when using FCP SCSI disk access, not with ECKD disk access. I find
this doc
e
> option is turned on. If we then try to turn it off, it is again flagged as
> an invalid option.
>
>
No file system cache is not supported for ckd, only FB disks....
here we have a lot of machines running z/linux SuSe Sp4 with DB2 9.7 .. but,
we use ckd for operation system an
We are conducting a proof of concept for one of our divisions. This includes
DB/2 9.7 and Suse 10 SP 3 with CKD dasd.
The first opportunity is the defines of tablespaces. In our x86 environment,
this runs in less that 3-4 minutes (yes, there are a lot of tables). In our
z/Linux guest that same
In my case (VSE), the mainframe documentation is in the PD for DB2/VSE.
Tom Duerbusch
THD Consulting
Sent via BlackBerry by AT&T
-Original Message-
From: "Dazzo, Matt"
Sender: Linux on 390 Port
Date: Tue, 1 Mar 2011 10:41:34
To:
Reply-To: Linux on 390 Port
Su
Tom, I have DB2 Conn Server installed, I reviewed the post installation steps
etc. Where are the next steps documented about configuring connections to say
db2 instances on the MF? Checked the Db2 info center and but can't find where
that stuff is? Kind of like where do I go next? Tks
After speaking w/DB2 admins here they came to the same conclusion you did. I
found the list feature cmd and as you can see no UDB. Thanks, I was not sure if
I missed something during the install.
[dasusr1@lndb2con V9.7]$ db2ls -q -p
Install Path : /opt/ibm/db2/V9.7
Product Response File
When I installed DB2 Connect, I used the VNC method of installing.
I did a "find / -name db2samp*.* from putty on my DB2 Connect Server. The file
wasn't found. I don't know what was used by the install process.
BTW, if you only have DB2 Connect and not DB2/UDB with it, would yo
I'm a zvm/Linux nubie looking for some help with DB2 Conn sever on Linux. I
have it installed and I am working on the post installation tasks, trying to
create the sample database but it seems the command 'db2sampl' is nowhere to be
found. According to the not so good db2 install
Hello again listeners,
I need set up ours db2 servers on cluster... what kind of solution are used
on z/linux ? anybody can share a how to or redbook or any paper about this?
Thanks !
Rogério Soares
--
For LINUX-390 subscribe
I'll check out those links... Thanks for the pointers.
On Sat, Oct 9, 2010 at 01:59, Joachim Schmidt <
joachim.schm...@oberquembach.de> wrote:
> hi,
>
> I've missed, that DB2 is on a different machine. How to get the
> ODBC-driver see
> "
> http://publ
hi,
I've missed, that DB2 is on a different machine. How to get the
ODBC-driver see
"http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.cli.doc/doc/t0023867.htm";.
How to install PDO_ODBC (ibm-db2) have a look at
"http://www.phpbuilde
ource name not found, and no default
driver specified
Since DB2 is actually on a different machine, were do I find the
syntax definitions for that?
I didn't expect it to work because DB2 is on a different machine...
but that does show I have PDO. :-) How do I tell if I have ODBC
ibm-db2 driver
hi,
have you checked, e.g. with phpinfo() , wether PDO (odbc) and PDO
Driver for ODBC (ibm-db2) is enabled?
if it is, try this:
...
...
$database= "your-DB";
$username="your_dbuser";
$password="your_DB2pw";
try {
$dsn="odbc:$database";
$c
I'm running RHEL 5.5 on zVM and DB2 running on a different host system
(also zLinux, but that doesn't matter)
>From the first system, I want to access DB2 using PHP. (Not via
Apache, I'm using PHP for some scripting)
Seems straightforward enough but I need the IBM Data Serv
We are moving away from DB2 - to Oracle LoZ.
Gerard
-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Barton
Robinson
Sent: Friday, July 30, 2010 2:57 PM
To: LINUX-390@vm.marist.edu
Subject: Re: DB2 direct i/o question
But, Oracle is VERY virtual
But, Oracle is VERY virtual friendly, and DB2 is VERY virtual HOSTILE.
From a system performance perspective, I REALLY LIKE Oracle.
Mark Post wrote:
On 7/30/2010 at 12:03 PM, Marcy Cortes wrote:
Does this make Oracle a better fit on Linux on z than DB2?
That depends on how much you care
Mark wrote:
>That depends on how much you care about newer versions being certified
>sometime within your life time.
Very good point. That's a concern too.
Marcy
--
For LINUX-390 subscribe / signoff / archive access instructi
>>> On 7/30/2010 at 12:03 PM, Marcy Cortes
>>> wrote:
> Does this make Oracle a better fit on Linux on z than DB2?
That depends on how much you care about newer versions being certified sometime
within your l
Klaus wrote:
"This is a DB2 limitiation which others, e.g. Oracle on zLinux, do not have."
Yes. What is up with that IBM? Does this make Oracle a better fit on Linux on
z than DB2?
Marcy
--
For LINUX-390
On Mon, 26 Jul 2010 10:17:51 -0500
Marcy Cortes wrote
"After reading some more, it turns out you cannot do direct i/o on linux
for
z if you are using ECKD dasd, only FCP."
This is a DB2 limitiation which others, e.g. Oracle on zLinux, do not have.
Klau
On Tue, Jul 27, 2010 at 2:24 AM, Shane G wrote:
> Short answer, no.
>
> On Tue, Jul 27th, 2010 at 1:17 AM, Marcy Cortes wrote:
>
>> Is there a way to limit the amount of memory used for page cache?
Longer answer: only by not giving Linux a lot of memory in the first
place... by avoiding larger
Short answer, no.
This was discussed earlier in the year - see:
http://www.mail-archive.com/linux-390@vm.marist.edu/msg55911.html
Shane ...
On Tue, Jul 27th, 2010 at 1:17 AM, Marcy Cortes wrote:
> Is there a way to limit the amount of memory used for page cache?
ender immediately by reply e-mail and delete this message. Thank you for
your cooperation."
-Original Message-
From: Linux on 390 Port [mailto:linux-...@vm.marist.edu] On Behalf Of Rob van
der Heij
Sent: Saturday, July 24, 2010 1:58 AM
To: LINUX-390@vm.marist.edu
Subject: Re: [LINUX-390] DB
On Sat, Jul 24, 2010 at 4:28 AM, Shane G wrote:
>> Does this imply that the best setting for Linux on z is to use the FILE
>> SYSTEM CACHING (Direct i/o disabled)?
Now that DB2 can, that's probably a good motivation for doing
measurements... I have mixed feelings about their d
On Sat, Jul 24th, 2010 at 10:20 AM, Marcy Cortes wrote:
> Does this imply that the best setting for Linux on z is to use the FILE
> SYSTEM CACHING (Direct i/o disabled)?
I won't presume to be able to answer that, but I will observe that Linus has
made some very harsh comments about database devel
>From the DB2 9.5 doc
Prior to Version 9.5, the keyword FILE SYSTEM CACHING was implied if neither NO
FILE SYSTEM CACHING nor FILE SYSTEM CACHING was specified. With Version 9.5, if
neither keyword is specified, the default, NO FILE SYSTEM CACHING, is used.
This change affects only ne
1 - 100 of 772 matches
Mail list logo
