DB2 db2start command for Linux on System z
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 same distro with no problems. Any ideas? -- Cameron Seay, Ph.D. Department of Computer Systems Technology School of Technology NC A & T State University Greensboro, NC 336 334 7717 x2251 -- 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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: DB2 db2start command for Linux on System z
What's in your PATH variable? On my system, /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 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't have to do that; you could just do all the typing. But why, when shells are so convenient? :-) Good luck, --Jim-- "We can do no great things; only little things with great love" --Mother Teresa |> | From: | |> >--| |Cameron Seay | >--| |> | To:| |> >--| |LINUX-390@vm.marist.edu | >--| |> | Date: | |> >--| |07/05/2014 15:08 | >--| |> | Subject: | |> >--------------------------| |DB2 db2start command for Linux on System z | >--| 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 same distro with no problems. Any ideas? -- Cameron Seay, Ph.D. Department of Computer Systems Technology School of Technology NC A & T State University Greensboro, NC 336 334 7717 x2251 -- 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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/ -- 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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: DB2 db2start command for Linux on System z
You, sir, are a steely-eyed missleman. All works just as you said it would. How do I create a user who can in turn create their own databases. Can I just use SQL syntax? On Sat, Jul 5, 2014 at 3:34 PM, James Tison wrote: > > What's in your PATH variable? > > On my system, /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 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't have > to do that; you could just do all the typing. > But why, when shells are so convenient? :-) > > Good luck, > --Jim-- > > "We can do no great things; only little things with great love" --Mother > Teresa > > > |> > | From: | > |> > > >--| > |Cameron Seay > > | > > >--| > |> > | To:| > |> > > >--| > |LINUX-390@vm.marist.edu > > | > > >--| > |> > | Date: | > |> > > >--| > |07/05/2014 15:08 >| > > >--------------------------| > |> > | Subject: | > |> > > >--| > |DB2 db2start command for Linux on System z >| > > >--| > > > > > > 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 same distro with no > problems. Any ideas? > > -- > Cameron Seay, Ph.D. > Department of Computer Systems Technology > School of Technology > NC A & T State University > Greensboro, NC > 336 334 7717 x2251 > > -- > 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/wlvindex?LINUX-390 > -- > For more information on Linux on System z, visit > http://wiki.linuxvm.org/ > > > -- > 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/wlvindex?LINUX-390 > -- > For more information on Linux on System z, visit > http://wiki.linuxvm.org/ > > -- Cameron Seay, Ph.D. Department of Computer Systems Technology School of Technology NC A & T State University Greensboro, NC 336 334 7717 x2251 -- 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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: DB2 db2start command for Linux on System z
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 you said it > would. How do I create a user who can in turn create their own databases. > Can I just use SQL syntax? -- 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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: DB2 db2start command for Linux on System z
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 Connection Information Database server= DB2/LINUXZ64 10.5.3 SQL authorization ID = DB2INST2 Local database alias = SAMPLE db2inst2@lnx049:~> db2 select * staff SQL0104N An unexpected token "sqllib" was found following "select bin db2inst2". Expected tokens may include: "FROM". SQLSTATE=42601 On Sun, Jul 6, 2014 at 3:07 AM, Neale Ferguson wrote: > 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 you said it > > would. How do I create a user who can in turn create their own > databases. > > Can I just use SQL syntax? > > -- > 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/wlvindex?LINUX-390 > -- > For more information on Linux on System z, visit > http://wiki.linuxvm.org/ > -- Cameron Seay, Ph.D. Department of Computer Systems Technology School of Technology NC A & T State University Greensboro, NC 336 334 7717 x2251 -- 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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: DB2 db2start command for Linux on System z
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. > SQL1026N The database manager is already active. > db2inst2@lnx049:~> db2 connect to sample > > Database Connection Information > > Database server= DB2/LINUXZ64 10.5.3 > SQL authorization ID = DB2INST2 > Local database alias = SAMPLE > > db2inst2@lnx049:~> db2 select * staff > SQL0104N An unexpected token "sqllib" was found following "select bin > db2inst2". Expected tokens may include: "FROM". SQLSTATE=42601 -- 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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/
Re: DB2 db2start command for Linux on System z
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/wlvindex?LINUX-390 -- For more information on Linux on System z, visit http://wiki.linuxvm.org/