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 <[email protected]> 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 <[email protected]> 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 [email protected] 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 [email protected] 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/
