Unanswered: using sequences crashes the db on Linux
I am facing a peculiar problem in my installation of v7.2 DB2 UDEE on Redhat Linux 7.2
The documentaion does not have any ref to the "CREATE SEQUENCE " cmd but when i gave the cmd on it it allowed me to create a sequece, drop it and even list it from the syscat.sequences !! BUT the minute i try to use nextval or prevval the DB happily crashes !!! If someone has any ans to this plz help ... I prefer not to use identity columns unless relly no alternative is present.