RE: SQL history lost moving to new i

["Ingvaldson, Scott" <scott.ingvaldson@xxxxxxxxxx>]

IIRC those are saved with the device names.  Are you using the same
Workstation IDs you used with the old machine?

Regards,

Scott Ingvaldson
Senior IBM Support Specialist
Midwest Region Data Center
Fiserv.


-----Original Message-----
From: Buck [mailto:kc2hiz@xxxxxxxxx] 
Sent: Thursday, November 19, 2009 11:44 AM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL history lost moving to new i

We moved to a new E4A a few weeks ago and everything went swimmingly.
Even the spooled files got restored to the new machine.  Today, one of
the developers tried STRSQL and discovered all her saved SQL statements
are gone.  Stupidly, I tried the same thing and found mine are gone too.

I say stupidly because I am well aware that they are stored in QRECOVERY
and are accessible-ish via DMPSYSOBJ ISQLST* QRECOVERY TYPE(19)
SUBTYPE(EE) I didn't think to dump the objects before accessing them and
apparently on first touch they get reset.

My question: How can I restore them so I can use DMPSYSOBJ?
  --buck