online reorg using wild card fails

[Former Member]

Hi All,

I am moving tables from a dictionary managed tablespace to a LMTS using brspace.

I can run the reorg for individual tables, but when I use a wildcard, it errors out:

>brspace -f tbreorg -s PSAPFACTD -t "/BI0/EZ*" -n PSAPR3FACT -p 3

BR1107E Table(s) /BI0/EZ* not found

BR0182E Checking parameter/option '-t|reorg_table' failed

It works fine when I run:

brspace -f tbreorg -s PSAPFACTD -t "/BIC/EZ5SEMC52B" -n PSAPR3FACT -p 3

Also,

I am not able to use -c option to run the process without a confirmation prompt:

brspace -f tbreorg -s PSAPFACTD -t "/BIC/EZ5SEMC52B" -n PSAPR3FACT -p 3 -c force

BR1001I BRSPACE 6.40 (32)

BR0153E Unknown option '-c' found at position 11

BR0154E Unexpected option value 'force' found at position 12

BR0700E Fatal errors occurred - terminating processing...

All advices will be valuable.

Many Thanks,

Cheers,

Nisch

[lbreddemann · Accepted solution]

> >brspace -f tbreorg -s PSAPFACTD -t "/BI0/EZ*" -n PSAPR3FACT -p 3

>

> BR1107E Table(s) /BI0/EZ* not found

> BR0182E Checking parameter/option '-t|reorg_table' failed

> It works fine when I run:

> brspace -f tbreorg -s PSAPFACTD -t "/BIC/EZ5SEMC52B" -n PSAPR3FACT -p 3

Is it just me or did you make a typo here?

The table name pattern was "/BI0/EZ*" (with 0 not C) and the full table name is "/BIC/EZ5SEMC52B". This table name will never match your search pattern.

> I am not able to use -c option to run the process without a confirmation prompt:

>

> brspace -f tbreorg -s PSAPFACTD -t "/BIC/EZ5SEMC52B" -n PSAPR3FACT -p 3 -c force

>

> BR1001I BRSPACE 6.40 (32)

> BR0153E Unknown option '-c' found at position 11

> BR0154E Unexpected option value 'force' found at position 12

The "-c force" option has to be specified before the -f <function> option. Be aware that the order of arguments matters for the brtools. Check the documentation or run "brspace -help" to get a short help text.

regards

Lars

[Former Member · Accepted solution]

Thanks for pointing that out to me Lars. I was getting impatient on getting this working. It is all working well now.

Best Regards,

Nisch