How to do...well...anything...in DB2 SQL
in [DB2]
|
Prev: SQL0901N Error.
Next: Convert DECIMAL to DATE
From: Ian Boyd on 10 Mar 2006 13:52 > Heh. > > I'm a wimp sticking to Stormrage. :) > > Though i got to level 4 on Earthen Ring when Stormrage was down at one > point. > > Hmm.. i wionder what db server *they* use. :) Bliz's website had job opening for people experienced in VLDB's on Oracle. Maybe they were switching to Oracle :) They are soooo ready for Oracle.
From: Ian Boyd on 10 Mar 2006 13:56 > Run db2level from a command window db2level Error: SQL0104N An unexpected token "END-OF-STATEMENT" was found following "db2level". db2level; Error: SQL0104N An unexpected token "END-OF-STATEMENT" was found following "db2level". begin atomic db2level; end Error: SQL0104N An unexpected token "db2level" was found following "begin atomic ". select db2level from sysibm.sysdummy1 Error: SQL0206N "DB2LEVEL" is not valid in the context where it is used. select db2level from sysibm.sysdummy1; Error: SQL0206N "DB2LEVEL" is not valid in the context where it is used. Ummm...i'll run it later :)
From: Ian Boyd on 10 Mar 2006 13:59 > you most > likely need a pagesize of 8K. > To create a system temporary tablespace you can run the command > "create system temporary tablespace TMPSPACE_8K > pagesize 8K > managed by system > using ('TMPSPACE_8K')" Error: SQL1582N The PAGESIZE of the table space "TMPSPACE_8K" does not match the PAGESIZE of the bufferpool "IBMDEFAULTBP" associated with the table space. SQLSTATE=428CB (State:428CB, Native Code: FFFFF9D2) If we dumped the database and started over with 8k, would the system's temp space also now be 8k? Is tempspace per database?
From: Gert van der Kooij on 10 Mar 2006 14:23 In article <dusi8k01tl3(a)enews1.newsguy.com>, Ian Boyd (ian.msnews010 @avatopia.com) says... > > you most > > likely need a pagesize of 8K. > > To create a system temporary tablespace you can run the command > > "create system temporary tablespace TMPSPACE_8K > > pagesize 8K > > managed by system > > using ('TMPSPACE_8K')" > > Error: SQL1582N The PAGESIZE of the table space "TMPSPACE_8K" does not match > the PAGESIZE of the bufferpool "IBMDEFAULTBP" associated with the table > space. SQLSTATE=428CB > (State:428CB, Native Code: FFFFF9D2) > > If we dumped the database and started over with 8k, would the system's temp > space also now be 8k? Is tempspace per database? > > Sorry about that, I forgot you also have to create a 8K bufferpool. If you start all over again using 8K as default, the bufferpool would also be 8K automatically. And yes, tempspace is per db.
From: Serge Rielau on 10 Mar 2006 14:39
Ian Boyd wrote: >> Run db2level from a command window > > db2level > Error: SQL0104N An unexpected token "END-OF-STATEMENT" was found following > "db2level". db2level is an executable (like db2start, db2stop). To get the information from SQL do: SELECT * FROM TABLE(ENV_GET_INST_INFO()) AS X Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab |