[SOLVED] CREATE TABLE LIKE in DB2 10 for z/OS throwing an error

CREATE TABLE LIKE in DB2 10 for z/OS throwing an error

Using DB2 for z/OS v.10, I'm getting an error when I specify a tablespace when using CREATE TABLE ... LIKE.

I can successfully use CREATE TABLE ... LIKE if I don't specify a new tablespace, but it throws an error when I specify a tablespace. The manual seems to say that this should work, but I must have an error in the syntax.

Create Table MySchema.Deleteme2
  Like MySchema.Deleteme;

Table MYSCHEMA.DELETEME2 created.

Create Table MySchema.Deleteme2
  Like MySchema.Deleteme
    in MYDB.SOMETS
;

THE STATEMENT COULD NOT BE PROCESSED BECAUSE ONE OR MORE IMPLICITLY CREATED OBJECTS ARE INVOLVED 1.

Any ideas?

Thank you for your help!

Dave

Solution

Resolved by ensuring that the target tablespace was first created with the correct attributes and permissions, before running the create table .... like ... in ...